| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I hide a cell formula from the formula bar
I want to enter a formula in a cell - but dont want it to appear in the
formula bar. Please let me know - how to go about it. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I hide a cell formula from the formula bar
Hi,
It takes a few steps so instead of me explaining have a look here http://www.techonthenet.com/excel/ce...e_formulas.php Mike "S. Shah" wrote: I want to enter a formula in a cell - but dont want it to appear in the formula bar. Please let me know - how to go about it. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I hide a cell formula from the formula bar
FormatCellProtectionUnlock the cell and enable Hidden
ToolsOptionsProtect Sheet................sheet MUST be protected Gord Dibben MS Excel MVP On Sat, 6 Dec 2008 13:40:00 -0800, S. Shah <S. wrote: I want to enter a formula in a cell - but dont want it to appear in the formula bar. Please let me know - how to go about it. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i hide cells using formula if the cell has no value? | Excel Discussion (Misc queries) | |||
| Protect individual cell and hide formula in formula bar | Excel Worksheet Functions | |||
| Hide the formula in a cell. | Excel Worksheet Functions | |||
| HOW DO I HIDE FORMULA IN A CELL | Excel Discussion (Misc queries) | |||
| Use formula to hide/delete cell? | Excel Worksheet Functions | |||
Hybrid Mode
