hide formulas on the worksheet

[Shariq]

I searched on help menu for hiding formulas on the sheet, so what I found was
this

Switch between displaying formulas and their values on a worksheet

Press CTRL + ` (grave accent).

but I've got no clue what it means to press control + ?? so what is this
grave accent?
how do I get it?
please help!

What I really want to do is in a worksheet what I have made for some
calculation pupose for other users too, to avoid any kind of overwriting in
those cells containing formulas, to be protected+hide the formulas anyhow so
what should be done to do this please somebody tell me.

thanks in advance

 

[Dave Peterson]

It's the shortcut that's equivalent to:

Tools|Options|View tab|Formulas

But I don't think that's what you want.

If you want to hide the formula, you'll have to lock the cell(s) and then
protect the worksheet.

Select the cells to lock (and hide).
format|cells|protection tab|check Locked and check Hidden

Now protect the worksheet:
tools|Protection|protect sheet

But this isn't foolproof. Worksheet protection is easily broken.

And be aware that there are lots of things you can't do on a protected
worksheet.

 

[Alan]

CRTl + ` doesn't hide formulas, its a quick way to show all the formulas in
a sheet. The ` is the key to the left on the keyboard just below the escape
key, you can toggle formulas by doing this.
To hide your formulas as you want to do, click 'Edit' on the top toolbar,
click 'GoTo', click 'Special', check 'Formulas', OK
This will highlight all your formulas. Right click on one of the highlighted
areas, 'Format Cells', 'Protection', check 'Locked' and 'Hidden', OK
Protect the sheet using Tools > Protection, apply a password if you want to
and there you go,
Regards,
Alan.