This tutorial demonstrates how to unlock cells in Excel and Google Sheets.
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.
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:
- In the Ribbon, go to Review > Unprotect Sheet.
- 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.)
Cells are now unlocked, and you can change them (e.g., change cell B2 from “Michael” to “Kevin”).
Unlock Cells in Google Sheets
You can also unlock a range of cells or a sheet and enable changes in Google Sheets.
- To see all protected ranges in Google Sheets, go to Data > Protected sheets and ranges.
- On the right side is the Protected sheets & ranges window. As you can see, the Sheet!B2:B9 range is protected. Click on it.
- Click the recycle bin icon to delete the protection from the range.
- The pop-up warning is displayed, click Remove to confirm.
As a result, the range B2:B9 is now unlocked and enabled for editing.