Excel protecting specific cells

Protecting specific cells in Excel allows for certain cells to be amended whilst others are protected from editing by other users.

The below worksheet has been protected in columns D and E to ensure they are not overwritten.

protecting specific cells - 1

This has been performed through the following process: –

Highlight the cells which should be open for editing and select format cells.

protecting specific cells - 2

On the protection tab the “Locked Cells” option should be unchecked.

protecting specific cells - 3

Right click on the tab and select “Protect Worksheet” the following pop up menu will appear.

protecting specific cells - 5

Ensure that “Select locked cells” is unchecked, this prevents the user selecting any locked cells after the protection is finalised.