Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell Protection
I would like to protect only certain cells within the Excel work book. Does
anyone know how to do this? The help menu only tells how to protect the complete work book/work sheet. Any help would be appreciated |
#2
|
|||
|
|||
Hi Liz
You need to select the range of cells that you don't want to be protected, then go to FomatCellsProtection and deselect the Protect button. Then, when you Protect the sheet, those cells will remain unprotected. -- Regards Roger Govier "Liz - HADC" <Liz - wrote in message ... I would like to protect only certain cells within the Excel work book. Does anyone know how to do this? The help menu only tells how to protect the complete work book/work sheet. Any help would be appreciated |
#3
|
|||
|
|||
Thanks Roger for your help
Liz "Roger Govier" wrote: Hi Liz You need to select the range of cells that you don't want to be protected, then go to FomatCellsProtection and deselect the Protect button. Then, when you Protect the sheet, those cells will remain unprotected. -- Regards Roger Govier "Liz - HADC" <Liz - wrote in message ... I would like to protect only certain cells within the Excel work book. Does anyone know how to do this? The help menu only tells how to protect the complete work book/work sheet. Any help would be appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
Cell Protection Issue | Excel Worksheet Functions | |||
cell protection | Excel Discussion (Misc queries) | |||
Conditional formating - cell protection | Excel Discussion (Misc queries) | |||
Cell Protection Color | Excel Discussion (Misc queries) |