Home › Unprotect an Excel sheet without the password

Unprotect an Excel sheet without the password

Why the password is not required

It feels like you should need the password to undo a password, but sheet protection does not work that way. When someone runs Review → Protect Sheet, Excel does not encrypt anything — it writes a single flag, <sheetProtection>, into the worksheet's XML and stores a hash of the password beside it. That flag is all that greys out your cells. The data is never scrambled, so re‑enabling editing means removing the flag, and the flag comes out whether or not you know the password that set it.

Remove it in your browser

The quickest route needs no password, no macro, and no install:

Make a copy of the workbook so the original is safe.
Drop the copy onto the unlock tool. It opens the ZIP package, deletes the <sheetProtection> tag from every locked worksheet — and <workbookProtection> if the workbook structure is locked too — and rebuilds the file, all in the page.
Download the copy and open it. Every cell accepts input again.

Nothing is uploaded; the whole edit happens on your device. If you would rather do it by hand, the manual ZIP method deletes the same tag with a text editor.

The one thing this will not do

Removing a sheet lock without the password works because the lock is not encryption. A file‑open password is: it runs the whole workbook through AES, and Excel will not show a cell without the correct password. If your file refuses to open at all, no password‑free method — including this one — can help, and the file is detected and refused rather than broken. The quick test is whether you can see your data: if you can, you are on the removable side of the line. If your tabs rather than your cells are locked, see workbook‑structure protection.

Unlock it in seconds instead

The manual route works, but our free in‑browser tool does the same thing in one drop — nothing is uploaded, everything runs on your device.

Unlock your file now →

Frequently asked

Is it safe to unprotect a sheet without the password?

Yes, as long as you have the right to edit the file. Only the protection flag is removed; cell values, formulas and formatting are untouched. Keeping a backup copy first is still sensible.

Does this recover the original password?

No, and it does not need to. Sheet protection is an edit lock, so the tool deletes the lock flag rather than recovering the password that set it.

What if the sheet was protected without a password?

Then Review → Unprotect Sheet lifts it instantly with no prompt — try that first. Many sheets are protected with a blank password purely to prevent accidental edits.