Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking cells
Is there a way to protect a cell on a shared spreadhseet that can be locked
so no one else can change it? I am using excel 2007. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking cells
Yes. You can right-click on the cell you want to protect, and choose Format
Cell. Click on the last tab, Protection, and make sure there is a check mark next to Locked. Then you will have to protect the Sheet by going up to the Review tab and clicking on Protect Sheet. You can customize your options and even choose if you want to use a password. "P. Zicari" wrote: Is there a way to protect a cell on a shared spreadhseet that can be locked so no one else can change it? I am using excel 2007. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking Cells | Excel Discussion (Misc queries) | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
Locking Cells | Excel Discussion (Misc queries) | |||
Locking cells | Excel Discussion (Misc queries) | |||
locking cells | Excel Discussion (Misc queries) |