Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
By default, if you choose to protect the cells in a worksheet, all cells on that worksheet are protected
However, if you want to protect only some of the cells (but not the rest), you can do the following steps 1) Select all the cells on the current worksheet (Ctrl + A 2) From the Format menu, choose "Cells 3) In the form that pops up, choose the "Protection" tab, uncheck the "Locked" checkbox. Click OK 4) Select those cells you would want to protect 5) From the Format menu, choose "Cells 6) In the form that pops up, choose the "Protection" tab, check the "Locked" checkbox. Click OK 7) From the "Tools" menu, choose "Protection", then "Protect Sheet" 8) Click OK Regards Edwin Ta http://www.vonixx.co ----- singkit wrote: ---- Hi Is there a way I can protect specific cell in a work sheet Please help Thank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect or Unprotect Cell dependent on different cell | Excel Discussion (Misc queries) | |||
Is it possible to protect cell formatting in an unlocked cell? | Excel Discussion (Misc queries) | |||
EXCEL: Protect a cell depending on another cell value | Excel Worksheet Functions | |||
how to protect one cell and not others | Excel Discussion (Misc queries) | |||
protect specific cell but allow edit on other cell | Excel Worksheet Functions |