Cell Protection

[Guest]

I would like to protect only certain cells within the Excel work book. Does
anyone know how to do this? The help menu only tells how to protect the
complete work book/work sheet.

Any help would be appreciated

 

[Roger Govier]

Hi Liz
You need to select the range of cells that you don't want to be protected,
then go to Fomat>Cells>Protection and deselect the Protect button.
Then, when you Protect the sheet, those cells will remain unprotected.

 

[Guest]

Thanks Roger for your help

Liz

Hi Liz
You need to select the range of cells that you don't want to be protected,
then go to Fomat>Cells>Protection and deselect the Protect button.
Then, when you Protect the sheet, those cells will remain unprotected.