| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hide formula
How Can I hide formula without locking it. please help
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Hide formula
Anand vijay
I am confused, if you hide the formula you hide the results of the formula. If you are doing this to use the results for another computation, why not incorporate your formula into the other formula? or just color the font white? Mike Rogers "Anand vijay" wrote: How Can I hide formula without locking it. please help |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Hide formula
Anand
FormatCells...ProtectionHidden and then protect the sheet will not show the formula in the formula bar, but I suspect that's what you don't want. You could turn off the formula bar via ToolsOptions...Viewun-check formula bar? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Anand vijay" wrote in message ... How Can I hide formula without locking it. please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide cell formula without losing formatting abilities | Excel Worksheet Functions | |||
| I would like to hide the following formula... | Excel Discussion (Misc queries) | |||
| Formula or Macro to hide a row based on a cell value | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Hide Formula in Formulabar | Excel Discussion (Misc queries) | |||
Linear Mode
