How to Edit a Locked Excel Sheet | Unprotect Cells Fast

A locked Excel sheet requires its password through the Review tab’s Unprotect Sheet option to unlock cells for editing.

A locked Excel sheet stops edits wherever it goes, but unprotecting it takes about ten seconds when you know the password. Here’s the official method for how to edit a locked Excel sheet without risking data or file integrity.

Editing a Locked Excel Sheet: The Official Route

The official way to unprotect a sheet is through the Review tab, where Excel asks for the password and removes restrictions once it’s entered. All locked cells, formatting controls, and sheet actions return to normal after unprotection.

1. Open the workbook in the desktop version of Excel.
2. Go to the Review tab on the ribbon.
3. Click Unprotect Sheet in the Protect group.
4. Type the password when prompted and press Enter.
5. Edit any cells that were previously locked.
6. Re-protect the sheet if needed by going back to Review > Protect Sheet and setting a new password.

The file saves with your changes; the sheet stays unprotected unless you re-apply protection manually.

Why Won’t Excel Let Me Edit Certain Cells?

Cells may reject edits even after unprotecting a sheet if they were formatted as Locked before protection was applied. Excel’s protection model only allows editing in cells marked Unlocked while the sheet is protected.

To check this, right-click a stubborn cell, choose Format Cells, go to the Protection tab, and see whether the Locked box is checked. If it is, you’ll need to unprotect the sheet first, then uncheck that box and re-apply protection. Cells that start as Unlocked remain editable even with the sheet protected — that’s how forms and data-entry templates work.

This is one of the most common confusion points: protecting the sheet locks all cells by default unless you explicitly unlock certain ones beforehand.

Removing a Password to Modify

When a workbook opens as read-only and asks for a modification password, you can clear that password through File > Save As > Tools > General Options if you’re authorized to do so. This setting controls whether the file suggests read-only access, not whether the file can be opened at all.

1. Open the workbook and go to File > Save As > Browse.
2. In the Save As dialog, click the Tools dropdown next to the Save button.
3. Select General Options.
4. Clear the Password to modify field, or replace it with a new one.
5. Click OK, then Save the file under the same name or a new one.

The next time the workbook opens, it will no longer prompt for a modification password. This method only works when you know the existing password or have permission to change it. The official Microsoft documentation explains both the unprotect sheet workflow and the password-to-modify settings through the Microsoft Learn Q&A on workbook protection.

Common Protection Mistakes That Trap Users

Three misunderstandings cause most of the confusion around locked Excel sheets.

Mistake 1: Confusing sheet protection with file encryption. Sheet protection blocks edits to cells and sheet actions; file encryption blocks the entire workbook from opening. Unprotecting a sheet does nothing to remove an open password, and clearing a “password to modify” does not remove a file encryption password. They are completely separate systems.

Mistake 2: Not unlocking cells before protecting the sheet. By default, every cell in Excel is formatted as Locked. When you protect the sheet, all locked cells become uneditable. If you want certain cells to remain editable, you must set them to Unlocked inside Format Cells > Protection before applying protection.

Mistake 3: Using nonstandard XML or VBA workarounds found online. Some guides suggest unzipping the workbook file and editing XML directly to remove protection. Those methods are not supported by Microsoft, can corrupt the file, and may violate policy. Always use the built-in unprotect workflow when you are authorized to do so.

What Happens When You Don’t Have the Password

If you don’t have the sheet password and can’t reach the person who set it, there is no official way to remove worksheet protection. Microsoft’s own guidance points only to contacting the workbook owner or the person who originally protected the sheet.

Methods that involve editing internal XML files, using VBA brute-force scripts, or applying third-party tools carry real file-corruption risk and aren’t supported by Microsoft. If the file is critical and the password is lost, the safest path is to recreate the data in a new workbook or ask the original author for an unprotected copy.

The Safe Sequence for Editing a Locked Sheet

1. Confirm authorization. Only unprotect a sheet you own or have explicit permission to modify.
2. Back up the file. Save a copy before changing any protection settings.
3. Use Review > Unprotect Sheet. This is the only official method for sheet-level protection.
4. Check cell-level formatting. If certain cells still won’t edit, verify they’re set to Unlocked under Format Cells > Protection.
5. Handle read-only prompts. Use File > Save As > Tools > General Options to clear a “password to modify” when authorized.
6. Re-protect after editing. Return to Review > Protect Sheet to restore restrictions once changes are complete.