hide formulas on the worksheet
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.
"Shariq" wrote in message
...
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
|