How to Unlock / Unprotect Cells in Excel & Google Sheets

In this tutorial, you will learn how to unlock cells in Excel and Google Sheets.

 

excel unlock cells

 

Unlock Cells

If you have a protected worksheet or range of cells, you can easily unlock it. (If the sheet is password-protected, you’ll need to provide the password to unlock it.) Say you have the following sheet with cells locked for editing and formatting.

 

unlock range of cells

 

If you select cell C2, you can see that all formatting options in the Home tab are grayed out, which means you can’t format the cell. Also, if you try to edit the content of the cell, you get the message that it is locked for changes. To unlock the cells, follow these steps:

  1. In the Ribbon, go to Review > Unprotect Sheet.

 

unlock range of cells 1

 

  1. If the sheet is password-protected, in the pop-up window, enter a password, and click OK. (If the sheet is not password-protected, skip this step.)

 

unlock range of cells 2

 

Cells are now unlocked, and you can change them (e.g., change cell B2 from “Michael” to “Kevin”).

 

unlock range of cells 3

 

If you need to lock the cells again, see How to Lock Cells or How to Password Protect a File.

Unlock Cells in Google Sheets

You can also unlock a range of cells or a sheet and enable changes in Google Sheets.

  1. To see all protected ranges in Google Sheets, go to Data > Protected sheets and ranges.

 

google sheets unprotect range

 

  1. On the right side is the Protected sheets & ranges window. As you can see, the Sheet!B2:B9 range is protected. Click on it.

 

google sheets unprotect range 1

 

  1. Click on the recycle bin icon to delete the protection from the range.

 

google sheets unprotect range 2

 

  1. The pop-up warning is displayed, click Remove to confirm.

 

google sheets unprotect range 3

 

As a result, the range B2:B9 is now unlocked and enabled for editing.

Note: To see, instead, how to (un)lock a cell reference, see Freeze Cell in Formula or How to Anchor a Cell.