how to lock a single cell?

  • Thread starter Thread starter has ex
  • Start date Start date
Hi
As default, all cells are locked - but the sheet is unprotected. Hit Ctrl+A
to select all cells and then from Format/Cells/Protection, uncheck Locked.
Now all of your cells are unlocked. Select the cell/s you wish to lock and
Format/Cells/Protection select Locked. To activate this, you now need to
protect the worksheet, from Tools/Protection/Protect Worksheet
 
Back
Top