Securing a cell.

P

Peter

Is there a way to lock the data in a cell so no other
user can edit it and still leave the edit ability in all
other cells?
Thanks.
 
B

Bernard V Liengme

Hi Peter,
1) Select the cell, use menu item Format|Cell; open Protection tab; click to
remove check mark in Locked box
2) Use menu item Tools|Protection and click Protect Sheet (password is
optional)
Best wishes
Bernard
 
G

Gord Dibben

Peter

Hit CRTL + A to select all cells.

Format>Cells>Protection> uncheck "locked".

Select the cell you want to lock.

Format>Cells>Protection> check "locked"

Tools>Protection>Protect Sheet.

Gord Dibben Excel MVP
 
Top