| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide the formula
Hi,
How can i hide the formula in some cell and keep some cells free, so that we can the enter the data. Friend in need... Mat |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide the formula
Format|Cells|Protection tab:
If hidden is checked, it will hide the contents of the cell (i.e.: the formula), when the sheet is protected. If Locked is unchecked, it will allow the person to enter data intot he cell when the sheet is protected. -- John C "Mat" wrote: Hi, How can i hide the formula in some cell and keep some cells free, so that we can the enter the data. Friend in need... Mat |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide the formula
Hi,
Thanx John. Mat "John C" wrote: Format|Cells|Protection tab: If hidden is checked, it will hide the contents of the cell (i.e.: the formula), when the sheet is protected. If Locked is unchecked, it will allow the person to enter data intot he cell when the sheet is protected. -- John C "Mat" wrote: Hi, How can i hide the formula in some cell and keep some cells free, so that we can the enter the data. Friend in need... Mat |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect individual cell and hide formula in formula bar | Excel Worksheet Functions | |||
| if/hide formula | Excel Worksheet Functions | |||
| Formula won't hide | Excel Discussion (Misc queries) | |||
| how to hide the formula | Excel Worksheet Functions | |||
| Hide formula | Excel Worksheet Functions | |||
Hybrid Mode
