Home › Forgot your Excel sheet‑protection password? Do not panic

Forgot your Excel sheet‑protection password? Do not panic

Good news: it is a lock, not a vault

If you set a Protect Sheet or Protect Workbook password months ago and cannot remember it, your data is not lost or scrambled. Sheet protection is an edit lock — Excel stores a hash of the password as a flag and simply refuses to let you change cells while the flag is set. The spreadsheet contents are never encrypted, so getting back in is about removing the flag, not cracking a cipher.

Edit lock vs. file‑open encryption

Before you do anything, work out which kind of password you forgot:

Edit lock (recoverable): the file opens fine, but cells are greyed out and Excel asks for a password only when you click Unprotect Sheet. This is the removable kind.
File‑open encryption (not recoverable): Excel demands a password before it will show the workbook at all. This is AES encryption; without the correct password the data is genuinely inaccessible, and no tool can bypass it.

Only the first case is what the steps below fix.

How to get editing back

Confirm you can still open and view the file — that tells you it is an edit lock, not encryption.
Drop a copy onto the unlock tool. It removes the sheet and workbook protection flags in your browser, without needing the forgotten password.
Download the result and open it — every cell and tab is editable again.

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

Do I need to remember or recover the password?

No. Because sheet protection is an edit lock rather than encryption, the protection flag can be removed without the original password.

How do I know it is not encryption?

If the file opens and you can see the data — only editing is blocked — it is an edit lock. If Excel refuses to open the file without a password, that is AES encryption and cannot be removed.

Is my data at risk during this?

No. The unlock runs in your browser, the file is never uploaded, and only the protection flag is removed — cell values and formulas are left unchanged.