Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection on particular cells
Hi........I have file that accessed by many persons but i want to protect the
cells except B5, B10 and E8 (they can enter the values on the three cells only) thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection on particular cells
You can do these one by one or all at once. All at once is probably easiest.
Left click B5 and then press and hold the Ctrl key on your keyboard. With the Ctrl key pressed left click B10 and E8. All 3 cells should now be highlighted. You can let go of Ctrl now. Right click on any of the cells and select 'Format Cells' from the menu. The far right tab of this dialogue box will be 'Protection', left click this to access it. Simply uncheck the 'Locked' option and these 3 cells will now be unlocked and remain active when you protect the sheet. Select 'OK' to close the dialogue box and you're all done. Hope that helps "Ravi" wrote: Hi........I have file that accessed by many persons but i want to protect the cells except B5, B10 and E8 (they can enter the values on the three cells only) thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
About protection of Cells | New Users to Excel | |||
Protection, cutting cells | Excel Discussion (Misc queries) | |||
Problem with protection of cells | Excel Discussion (Misc queries) | |||
Cells Protection | Excel Discussion (Misc queries) | |||
auto protection of cells | Excel Worksheet Functions |