Sheet Protection vs Workbook Protection vs Encryption
Excel uses the word "password" for three completely different features. Knowing which one you're facing tells you instantly whether it can be removed — and how. Here's the difference, in plain terms.
The three at a glance
| Feature | What it blocks | Real security? | Removable without password? |
|---|---|---|---|
| Sheet protection | Editing cells on one worksheet | No | Yes |
| Workbook protection | Adding, deleting, or reordering sheets | No | Yes |
| Encryption | Opening the file at all | Yes (AES) | No |
1. Sheet protection
This is the one most people mean by "the sheet is locked." You set it with Review → Protect Sheet. It stops anyone from editing cells, but the data is fully visible and the file opens normally.
Under the hood it's a single <sheetProtection> tag in the worksheet's XML. The password, if any, is stored only as a short hash for comparison — the cells themselves are never encrypted. That's why it can be removed without knowing the password, by deleting that one tag. See how to unprotect a sheet without the password.
You can open and view the file freely. The password prompt only appears when you try to edit a cell or click Unprotect Sheet.
2. Workbook structure protection
Set with Review → Protect Workbook, this locks the structure of the file: you can't insert, delete, rename, hide, or reorder worksheets. Individual cells remain editable (unless their sheet is also protected). It's commonly used on templates to stop people from rearranging tabs.
Like sheet protection, it's a single <workbookProtection> element in xl/workbook.xml, with only a password hash. It is equally removable without the password.
The sheet tabs at the bottom are visible but right-clicking them shows greyed-out options like "Insert" and "Delete."
3. File encryption ("Encrypt with Password")
This is the only one that is genuine security. Set with File → Info → Protect Workbook → Encrypt with Password, it encrypts the entire workbook with AES-256. The file's contents become unreadable bytes; nothing — not Excel, not a tool, not a text editor — can read them without the password.
If a site claims to "remove" encryption instantly and for free, be skeptical: genuinely breaking AES-256 is infeasible. The realistic options are password-recovery services that attempt to guess weak passwords by brute force, which is slow and not guaranteed.
Excel demands a password immediately on opening, before you can see any content at all.
Which one do you have?
Use this quick test:
- Does it ask for a password before you can see anything? → Encryption. Not removable without the password.
- Can you see the data, but editing a cell is blocked? → Sheet protection. Removable.
- Can you edit cells, but can't add or move sheets? → Workbook protection. Removable.
Got sheet or workbook protection?
Both come off in one step, right in your browser — no upload, no password needed.
Open the free unlocker →