Securing a cell.

  • Thread starter Thread starter Peter
  • Start date Start date
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.
 
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
 
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
 
Back
Top