Skip to content

How to Lock Cells in Excel

This article answers the question – how do you lock cells in Excel?

Well, it turns out that all the cells are locked by default. However, you must enable worksheet protection for that lock to do anything.

To learn how this all works, keep on reading!

How to Lock or Unlock Cells

By default, all cells in Excel have their protection formatting set to locked.

To change this setting, select the cells you want to change, right-click, and select format cells.

Under the Protection tab, you can check or uncheck the Locked checkbox to lock or unlock the cells.

Then press Ok to complete the lock or unlock.

How to Protect the Worksheet

Locked and unlocked cells do not behave any differently unless the worksheet protection is turned on.

To turn on worksheet protection, click on the Review tab in the Excel Ribbon and then click on Protect Sheet.

You can set a password that will be required to unprotect the worksheet, or you can leave this blank.

Next, select the permissions the user will have to interact with the locked cells.

Finally, click on Ok to enable the worksheet protection.

The locked cells are now protected in your worksheet.

Also, to unprotect the worksheet, go to Review Unprotect Sheet and enter the password if required.

And that is how you can lock and unlock cells in Excel.

This Post Has One Comment

  1. I feel like locking cells in Excel is one of those hidden gems that people forget about! This is super useful!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top