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.
This has been performed through the following process: –
Highlight the cells which should be open for editing and select format cells.
On the protection tab the “Locked Cells” option should be unchecked.
Right click on the tab and select “Protect Worksheet” the following pop up menu will appear.
Ensure that “Select locked cells” is unchecked, this prevents the user selecting any locked cells after the protection is finalised.