How to Remove a Password from an Excel Sheet
If Excel shows "The cell or chart you're trying to change is on a protected sheet", the worksheet has sheet protection turned on. The good news: this is an editing lock, not encryption — which means you can remove it in seconds, even if you don't know the password. Here's the fastest way, plus a manual method for the curious.
The fastest way — remove it online in seconds
Because sheet protection isn't encryption, a tool can strip it out directly without cracking anything. XLockFree does exactly that, entirely in your browser session, with no password required:
- Open XLockFree. Go to the unlock tool — nothing to install, works on any device.
- Upload your worksheet. Drag your
.xlsxor.xlsmfile onto the drop zone, or click to browse. Leave the password field blank — sheet protection needs no password. - Click "Unlock & Download". XLockFree removes the sheet protection (and any workbook lock) and your unlocked file downloads automatically.
- Open the downloaded file. Every cell is editable again, and all your data, formulas and formatting are untouched.
No password needed. Sheet protection is designed to prevent accidental edits, not to secure data — so removing it never requires the original password. If Excel prompts you for a password just to open the file, that's a different lock — see our guide to encrypted files.
Why this works: protection vs. encryption
Excel has two very different security features that people often confuse:
- Sheet (and workbook) protection — a flag stored inside the file that tells Excel to block editing. The file itself is not encrypted, so the flag can simply be removed. This is what this guide covers.
- File open password — real AES-256 encryption applied to the entire file. You must supply the correct password to decrypt it; it cannot be bypassed.
Removing sheet protection is therefore not "hacking" — it's deleting an editing preference from a file you can already open. That's why it's instant and safe.
The manual method (no tools)
Prefer to see how it works under the hood? A modern .xlsx file is really a ZIP archive of XML
files, and the protection lives in one line of that XML. You can remove it by hand:
- Make a copy of your file and rename its extension from
.xlsxto.zip. - Open the ZIP and navigate to
xl/worksheets/. Each sheet is a file likesheet1.xml. - Edit the sheet XML and delete the entire
<sheetProtection ... />tag. - Save, re-zip, and rename the archive back to
.xlsx. The sheet is now unprotected.
Why most people skip this. The manual route is fiddly, breaks easily if the re-zip includes an extra folder level, and doesn't work for .xlsm macros or multiple sheets at once. XLockFree automates the exact same surgery — losslessly — across every sheet in one click.
Does this work on Mac, mobile and older files?
Yes. XLockFree runs in the browser, so it works identically on Windows, macOS, Linux, iPhone and Android —
no Office install required. It also handles the legacy .xls format and macro-enabled
.xlsm / .xlam files, removing sheet protection from all of them.
Troubleshooting
The cells are still locked after downloading
Make sure you opened the downloaded file (named unlocked_…), not your original. If a specific range is still locked, the workbook may also have a structure lock — unprotecting the workbook clears that too.
Excel asks for a password before the file even opens
That's file-level encryption, not sheet protection. Follow the encrypted-file guide and enter the open password.
Unlock your protected sheet now
Free, private, no sign-up. Your file is processed in-memory and never stored.
Open XLockFree →Frequently asked questions
Can I remove Excel sheet protection without the password?
Yes. Sheet protection is an editing restriction, not encryption, so it can be removed without knowing the password. Upload the file to XLockFree and it strips the protection instantly.
Is removing sheet protection legal?
It is legal to remove protection from files you own or are authorized to edit — your own spreadsheets, or workbooks shared with you by your organization. Do not modify files you have no right to change.
Does removing the sheet password delete my data?
No. Only the protection layer is removed. Every cell value, formula, chart and format stays exactly as it was.
What's the difference between sheet protection and a file open password?
Sheet protection only blocks editing and can be removed without a password. A file open password encrypts the whole file, so you must know that password to decrypt it.