Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lock cell
By default, all cells are locked, but only if the sheet is protected. To
turn on sheet protection: Select Tools/Protection/Protect Sheet from Excel's menu. You'll probably want to leave some cells unlocked. To do so, first unprotect the sheet. then select the cells you want to unlock. Then from the Excel menu select Format/Cells. Clock on the Protection tab and make sure the checkbox labeled "Locked" is not checked. Finally, protect the sheet again. HTH Phil Webb "Mohamed" wrote in message ... How to lock a cell which contains a formula |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to lock the Ctrl key? (as locking the Shift key w/Caps Lock) | Excel Discussion (Misc queries) | |||
how do I undo the scroll lock, thscroll lock button does not work | Excel Discussion (Misc queries) | |||
I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions |