You click a cell, start typing, and Excel refuses with a warning that the sheet is protected. Sheet protection is useful for preventing accidental edits, but it becomes a real headache when you need to make a change and don’t have the password.
This guide covers every practical way to unprotect an Excel sheet, from the one-click fix to the workarounds for when the password is gone.
Quick Answer: How to Unprotect an Excel Sheet
In a hurry? Find your situation below and jump to the right fix.
| Your situation | Best method | Time needed | Difficulty |
| You know the password | Review tab > Unprotect Sheet, then enter the password | Under 1 minute | Very easy |
| Forgot the sheet password (.xlsx file) | Rename to .zip, delete the sheetProtection tag in the sheet’s XML, rename back | 5-10 minutes | Medium |
| Sheet still lets you select cells | Select all (Ctrl + A), copy, and paste into a new workbook | 2 minutes | Easy |
| Forgot the password, want a quick workaround | Upload to Google Sheets, then download as .xlsx | 3-5 minutes | Easy |
| Can’t add, rename, or delete sheets | Review > Protect Workbook (or remove the workbookProtection tag in workbook.xml) | 1-10 minutes | Easy to medium |
| Excel asks for a password before opening | This is file encryption, not sheet protection. You need the password or a backup copy | N/A | Not bypassable |
Short version: If you know the password, use Review > Unprotect Sheet. If you don’t, the XML edit is the most reliable method for .xlsx files. Always work on a copy.
Understanding Excel Protection
Excel has three kinds of protection, and knowing which one you’re facing saves time:
- Sheet protection blocks editing cells, formatting, or inserting rows on a specific worksheet. This is what most people mean by a “protected sheet.”
- Workbook structure protection prevents adding, deleting, renaming, or moving sheets.
- File encryption requires a password just to open the file.
Sheet protection is designed to prevent accidental changes, not to act as strong security. Real encryption is a different matter, which we’ll cover below.
A quick note on ethics: only unprotect files you own or have permission to edit. If someone locked a shared document on purpose, ask them for the password first.
Method 1: Unprotect a Sheet When You Know the Password
This takes seconds.
- Open the workbook and select the protected sheet.
- Click the Review tab.
- In the Protect group, click Unprotect Sheet.
- Enter the password if prompted and click OK.
You can also right-click the sheet tab at the bottom of the window and choose Unprotect Sheet. If no password box appears, the sheet was protected without one and unlocks immediately. Once unlocked, the button changes to Protect Sheet.
If the option is greyed out, check for these common causes:
- The file is in Protected View. Click Enable Editing in the yellow bar at the top.
- The workbook is marked Final or opened Read-Only. Clear this under File > Info > Protect Workbook.
- You’re using Excel for the web, which has limited protection features. Open the file in the desktop app instead.
Method 2: Remove Protection Without a Password (XML Edit)
This is the most dependable method for modern .xlsx files, and it needs nothing beyond a ZIP tool. An .xlsx file is really a compressed folder of XML files, and the sheet’s protection setting is a single line inside one of them.
Make a copy of your file first and work on the copy.
On Windows
- In File Explorer, click View > Show > File name extensions.
- Rename Budget.xlsx to Budget.zip and confirm the warning.
- Open the ZIP with Windows’ built-in extractor, 7-Zip, or WinRAR.
- Go to the xl > worksheets folder. Files named sheet1.xml, sheet2.xml, and so on correspond to your sheets, usually in tab order.
- Copy the correct sheet file out of the archive and open it in Notepad.
- Press Ctrl + F and search for sheetProtection. You’ll find a tag like this: <sheetProtection password=”XXXX” sheet=”1″ objects=”1″ scenarios=”1″/>
- Delete the entire tag, from <sheetProtection through the closing />, without removing surrounding tags.
- Save the file, copy it back into the ZIP to replace the original, and rename the archive back to .xlsx.
Open the file and the sheet should be fully editable with no password required.
On Mac
The process is the same with two differences. Change the extension using Get Info (Cmd + I) or Terminal. Then, after editing the XML, re-compress the files (select the contents, not the outer folder) and rename the result to .xlsx.
If something goes wrong
- The file won’t open after re-zipping. The archive probably has an extra parent folder. The top level should contain [Content_Types].xml, xl, _rels, and docProps.
- You can’t find sheetProtection. You likely opened the wrong sheet file. Check the others.
- It’s an old .xls file. This method only works on .xlsx. Open the file in Excel and use Save As to convert it first.
Method 3: Copy the Data to a New Workbook
If the sheet still lets you select cells, you can skip the lock entirely:
- Click any cell and press Ctrl + A to select everything.
- Press Ctrl + C to copy.
- Open a new workbook, click cell A1, and press Ctrl + V.
You’ll get your data and usually your formulas in an editable sheet, though you may need to redo some formatting. This won’t work if “Select locked cells” was disabled when the sheet was protected.
Method 4: Use Google Sheets
Another quick workaround is to let Google Sheets import the file:
- Upload the Excel file to Google Drive.
- Right-click it and choose Open with > Google Sheets.
- Go to File > Download > Microsoft Excel (.xlsx).
In many cases, sheet-level protection doesn’t carry over during import, leaving you with an editable copy. Results vary, and complex formatting or macros may not survive the conversion, so check the output carefully.
A Word on VBA Macros
Many online tutorials suggest a VBA macro that tries password combinations until one works. This was popular for older files, but it’s a weak option today. It’s often ineffective on newer Excel versions, can run for a very long time on longer passwords, and requires enabling macros, which is risky if the code comes from an untrusted source. For most people, the XML method is faster and safer.
How to Unprotect a Workbook Structure
If you can’t add, delete, or rename sheets, the workbook structure is protected, which is separate from sheet protection.
- With the password: go to Review > Protect Workbook, enter the password, and click OK.
- Without the password: use the XML approach, but edit xl/workbook.xml instead. Find the workbookProtection tag, delete it, save, and re-zip.
What If Excel Asks for a Password to Open the File?
If Excel asks for a password before the file even opens, that’s file encryption, and the tricks above won’t work.
- If you know the password: open the file, go to File > Info > Protect Workbook > Encrypt with Password, clear the password box, click OK, and save.
- If you’ve lost it: modern Excel encryption is strong, and there’s no simple way around it. Check for an earlier unencrypted version, look through email and cloud backups, search your password manager, or ask the file’s creator.
Be wary of software promising to crack any encrypted file instantly. Many of these tools don’t work, and some carry malware.
Troubleshooting at a Glance
| Problem | Likely fix |
| File corrupted after editing XML | Re-zip so the top-level folders sit at the archive root |
| Can’t rename the file extension | Enable “File name extensions” in File Explorer |
| Unprotect option is greyed out | Turn off Protected View, Read-Only, or Mark as Final |
| Google Sheets broke the formatting | Use the XML method instead |
| Nothing works on an .xls file | Convert to .xlsx first, then retry |
Tips to Avoid Getting Locked Out Again
- Use a password manager so sheet and file passwords are never lost.
- Keep an unprotected master copy and share only the protected version.
- Leave a note about your protection settings in your master copy for future reference.
- Use real encryption for sensitive data. Sheet protection prevents accidents, not determined access.
Frequently Asked Questions
Is it legal to unprotect an Excel sheet without a password?
Generally, yes, for files you own or are authorized to edit. Bypassing protection on files you have no right to modify can violate policies, contracts, or laws. When in doubt, ask the owner.
Will unprotecting delete my data or formulas?
No. Removing protection only changes editing permissions. Still, work from a backup copy.
Does the XML method work on every Excel version?
It works on any .xlsx file (Excel 2007 and later). Older .xls files must be converted first.
Why does Excel still say the sheet is protected after I edited the XML?
You may have edited the wrong sheet file, or the changed file wasn’t saved back into the archive correctly. Repeat the steps on a fresh copy.
Conclusion
Unprotecting an Excel sheet is usually simple. With the password, Review > Unprotect Sheet takes seconds. Without it, the XML edit is the most reliable option for .xlsx files, with copy-to-new-workbook and Google Sheets as quick alternatives. Just remember the difference between sheet protection and file encryption, since only the first can be bypassed this easily.
Whichever method you choose, work on a copy, make sure you have the right to edit the file, and store your passwords somewhere safe so you don’t end up locked out again.
