Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect selected column
Dear Friend
Is there any possibilities to protecet by password only selected column or cel or row without protecting whole work sheet. thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect selected column
Yes
Highlight column or cells that you do NOT want to protect then Format Cells Protection and untick 'Locked' OK. Now protect the worksheet and you will be only be able to make entries in the column/cells that you unlocked. Hope this helps. "Fareez" wrote: Dear Friend Is there any possibilities to protecet by password only selected column or cel or row without protecting whole work sheet. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to protect only some selected cells in excel 2007? | Excel Discussion (Misc queries) | |||
Protect selected cells without protecting worksheet | Excel Discussion (Misc queries) | |||
Protect / Block selected worksheet area . | Excel Discussion (Misc queries) | |||
How do I protect selected cells on my worksheet? | Setting up and Configuration of Excel | |||
How do I protect selected cells on my worksheet? | Setting up and Configuration of Excel |