excel training courses london - CELL PROTECTION

Cells are protected with this two stage process.

Select the cells you want to protect

Click on FORMAT> Cells, then navigating to the PROTECTION Tab, you will see a tick box saying locked.

Cells are locked by default, but are only activated once you switch the functionality on.
To do this, click on TOOLS > PROTECTION > PROTECT SHEET.

As cells are locked by default, so your would need to unlock the cells you do not want to protect.