Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect individual cell and hide formula in formula bar
How to Protect individual cell and hide formula in formula bar
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect individual cell and hide formula in formula bar
Hi Ashish
Select and right click cell - in pop up Select Format Cells \ Next select Tab - Protection. Here select Locked and hidden cell. Now go to Menu "Tools \ Protection " and enter formula. Now the formula entered in selected cell will not be visible. Also cell will now be un-editable Regards Beena K "Ashish Saxena" wrote: How to Protect individual cell and hide formula in formula bar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HIDE AND PROTECT A CELL | Excel Worksheet Functions | |||
Locking cell to protect the formula | Excel Discussion (Misc queries) | |||
HOW DO I HIDE FORMULA IN A CELL | Excel Discussion (Misc queries) | |||
How do I protect a cell formula from being overwritten | Excel Discussion (Misc queries) | |||
protect formula in cell and still allow data deletion | Excel Discussion (Misc queries) |