How to Protect Only Specific Cells in Excel?

When you need to send someone a spreadsheet and want to make sure that no changes to any formulas are made, you can resort to locking a sheet or workbook.
It is also possible to lock specific cells. That way you can protect your document from changes in certain places, while other cells can easily be edited. Here is how you can do it:

The first step is to select all cells in the spreadsheet.

select all cells in excel

Right-click on them, then choose Format Cells – Protections and tick the Locked button.

format cells in excel

unlocked

Now all of the cells are unprotected.

The second step is to enter data in all the cells you want protected, and select them. The Go To functionality can prove useful for that.

After selection, repeat the step above: Format Cells – Protections, then tick the Locked button.

lock cell excel

The last step requires you to go to Review – Changes – Protect Sheet.

protect sheet in excel

Enter the desired password. Make sure not to forget it.

And that would be all. This way you can make sure that crucial data stays unchanged.

Categories Excel