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

[jjmorelli]

how ca I protect a single cell on a workbook

 

[Gord Dibben]

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