Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide formulas on the worksheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide formulas on the worksheet
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. Shariq wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Formulas, Worksheet to Worksheet - Excel 2003 | Excel Discussion (Misc queries) | |||
copy worksheet to a new workbook with formulas .... but new file not point to old one | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Using worksheet names in formulas | Excel Discussion (Misc queries) | |||
copying formulas from worksheet to worksheet | Excel Discussion (Misc queries) |