Get the Excel Unprotect Cheat Sheet
All the steps from the video on one page. Print it or keep it open while you work. Fast reference, no fluff.
Unprotect an Excel sheet without password (ZIP method)
1. Make a backup copy (important)
First, make a copy of your Excel file.
- Open the Windows File Explorer.
- Right-click on the file, select “Copy”.
- Paste it somewhere safe.
This prevents data loss if something goes wrong.
2. Rename the file from .xlsx to .zip
Rename the copied file from “.xlsx” to “.zip.” Here’s how:
- Right-click on the copied file.
- Select “Rename” from the context menu.
- Change the file extension from “.xlsx” to “.zip“.
- Press “Enter.”
- If you see a warning about changing the file type, click “Yes” to proceed.
💡 If you don’t see the file extension:
- Open File Explorer.
- Click on the “View” tab at the top.
- Hover over “Show” in the drop-down menu.
- Click on “File name extensions.”
- Ensure there’s a check mark next to “File name extensions” to show the file extensions.
3. Open the ZIP file (7-Zip or WinRAR)
- Open the ZIP file using a program like WinRAR or 7-Zip.
- If you don’t have one, you can download 7-Zip for free.
4. Go to xl → worksheets
- Inside the ZIP file, double-click the “xl” folder.
- Next, double-click the “worksheets” folder.
- You will see XML files for each worksheet in your Excel file.
5. Find the protected sheet XML (search for “protect”)
If you already know which sheet has the protection you want to remove, you can skip this step.
Otherwise, follow these instructions to identify the protected sheet:
- Double-click on the XML file to open it.
- If this does not open the file, right-click on the XML file and select “Open with.”
- Choose “Notepad” or another text editor. (If “Notepad” is not listed, you may need to click “Choose another app” and select it from there.)
- Once the file is open, search for the word “protect” by using the shortcut Ctrl + F.
The file that contains this word is the one you need to edit.
Confused by the XML code? Don’t risk breaking your file. Download the visual ‘One-Page Unprotector’ PDF to see exactly which line to edit.
6. Delete the sheetProtection line
Once you have identified the correct XML file (in our example, it is “sheet1”), follow these steps to unprotect the Excel sheet.
- Drag the XML file to your desktop. You can use the shortcut Win + Home to minimize all other open windows.
- Right-click on the XML file and select “Open with.”
- Choose “Notepad” or another text editor. (If “Notepad” is not listed, you may need to click “Choose another app” and select it from there.)
- Use the keyboard shortcut Ctrl + F to find the line that says “sheetProtection”.
- Select the entire line: from the opening bracket (“<“) until the closing bracket (“>“).
- Delete the selected line.
- Save the file using the keyboard shortcut Ctrl + S.
7. Save and replace the edited XML in the ZIP
- Delete the original XML file from the ZIP archive.
- Then, drag the modified XML file back into the ZIP archive.
8. Rename the file back from .zip to .xlsx
- Close the Zip-file
- Open File Explorer and rename the file from “.zip” back to “.xlsx“.
- Confirm the change when prompted.
9. Open the file, the sheet is unprotected
Open the Excel file. Your previously protected sheet should now be unprotected, allowing you to edit it.
Important notes before you unprotect a sheet
- Always create a backup before you start.
- Follow each step carefully to avoid corrupting your file.
- After unprotecting the sheet, set a new password you can remember.
Once your sheet is unprotected, it’s a good time to review how it’s set up. If the original creator used drop-down lists for data entry, you can now edit or expand those lists freely.
If rows or columns are still hidden after unprotecting, you may need to unhide them separately. Sheet protection and hidden rows are independent settings.
Fix: Excel “Corrupted File” Warning (Technical Note)
After renaming the file back to .xlsx, Excel may show a warning that it “found a problem with content” and needs to repair the file.
This is normal. Click “Yes” to proceed. Excel will fix the formatting metadata and open the file cleanly.
Pro Tip: If you see formula errors after the repair, open the file in Excel for the Web (free at office.com), let it recalculate, then use File > Save a Copy to download a clean .xlsx version.
Download the one-page cheat sheet
Keep the Unprotect Quick-Guide on your desktop so you never have to search for these steps again.
Featured Bundle
Black Belt Excel Bundle
Leila Gharani
Founder of XelPlus and ten-time Microsoft MVP. Leila helps over 500,000 professionals master Excel, Power BI, and data automation through practical, real-world training.
