How to Remove Excel Sheet Protection Without a Password

Locked out of your own Excel spreadsheet? You're not alone. Thousands of users every day discover that their .xlsx files have sheet-level protection that prevents editing cells, sorting data, or modifying formulas. The good news: this type of protection is easy to remove — and you can do it for free, right in your browser.

What is Excel Sheet Protection?

Excel's "Protect Sheet" feature (found under Review → Protect Sheet) lets users lock a worksheet with an optional password. When active, it prevents modifications to cells, formatting, and structure. It's commonly used in templates, shared workbooks, and financial models to prevent accidental edits.

However, sheet protection is not encryption. It's a simple XML flag stored inside the .xlsx file. Unlike file-open passwords (which use AES-256 encryption), sheet protection can be removed without knowing the password. Learn about the difference in our guide on Excel password types.

Method 1: Use XL Unlocker (Recommended)

The fastest and safest method:

1. Go to XL Unlocker.com
2. Check the authorization box confirming you own the file
3. Drag and drop your .xlsx file into the upload zone
4. Your unlocked file downloads automatically in seconds

Your file never leaves your browser — all processing happens client-side using JavaScript. Read our Privacy Policy for details.

Method 2: Manual XML Editing

Since .xlsx files are ZIP archives containing XML, you can manually remove protection:

1. Rename .xlsx to .zip
2. Extract the ZIP contents
3. Open xl/worksheets/sheet1.xml in a text editor
4. Find and delete the <sheetProtection ... /> tag
5. Save, re-zip, and rename back to .xlsx

This is exactly what XL Unlocker automates — but across all sheets simultaneously and without risk of corrupting the file.

Method 3: Using VBA Macro

You can also use a VBA macro inside Excel, but this requires enabling macros and has security implications. It also only works if the workbook itself isn't protected. Our online tool is simpler for most use cases.

What This Tool Cannot Do

It's important to understand the limitations:

• File-open passwords — These use AES-256 encryption and cannot be removed without the password
• .xls files — The legacy binary format requires different handling. Save as .xlsx first. See our guide on fixing read-only Excel files
• DRM-protected files — Enterprise rights management requires organizational access

Frequently Asked Questions

Is it legal to remove sheet protection?

Yes, when performed on files you own or have authorization to modify. See our Terms of Service.

Is my file safe?

Absolutely. Your file is processed entirely in your browser. It's never uploaded to any server. Check our Privacy Policy for full details.