how do I protect a single cell from being change in excell

  • Thread starter Thread starter Guest
  • Start date Start date
Select all cells and Format>Cells>Protection.

Clear the "Locked" option and OK

Select a single cell and enable the "locked" on that cell.

Now Tools>Protection>Protect sheet.


Gord Dibben MS Excel MVP
 
Back
Top