Unprotect a Sheet
Review > Unprotect Sheet lifts sheet protection, and if whoever protected the sheet left the password box empty it comes off instantly with no prompt. That is always worth trying first, because a protected sheet does not necessarily have a password on it. If a prompt does appear and you do not have the password, Excel offers no command that lifts it. And before assuming sheet protection at all, check what is really blocking you: a greyed-out ribbon on a freshly downloaded file is Protected View, and a workbook that only offers Save As is read-only — neither of those is protection on the sheet.
A worked example
A colleague sends a budget workbook. It opens normally, but typing into B7 raises Excel's warning that the cell sits on a protected sheet.
Review > Unprotect Sheet
The button flips to Protect Sheet and every cell becomes editable, with no dialog in between. That is the outcome for a large share of protected sheets, because the password field in Protect Sheet is optional and frequently left blank — protection was only ever there to stop accidental edits. If a password dialog does appear, that sheet genuinely has one and only that exact string will lift it.
Which one do I need?
| If you want to… | Use |
|---|---|
| Typing in a cell warns that it sits on a protected sheet | Review > Unprotect Sheet, which lifts immediately unless a password was set |
| The cells cannot even be clicked, let alone typed into | The sheet was protected with "Select locked cells" cleared; unprotecting restores selection, and there is no separate setting to switch back on |
| Sheet tabs cannot be renamed, moved, inserted or deleted, but cells edit fine | That is workbook-structure protection rather than sheet protection — Review > Protect Workbook toggles it off |
| Excel demanded a password before the workbook would open at all | That is file-open encryption, a separate mechanism with no way past it without the password |
| The whole ribbon is greyed out and a yellow bar sits across the top | The file is in Protected View after being downloaded or emailed — click Enable Editing; nothing is protected at all |
| The workbook opens but only offers Save As, or announces that it is final | Read-only recommended or Mark as Final, either of which any reader can override in one click |
| Whole sheets appear to be missing from the workbook | They are hidden rather than protected; if Unhide is greyed out too, workbook-structure protection is what is keeping them hidden |
| You need to protect a sheet rather than unprotect one | Protection and cell locking are two halves of one mechanism: every cell already carries a Locked flag that does nothing until the sheet is protected, so clear it from the cells people must fill in before switching protection on |
| A sheet-protection password has genuinely been lost | Excel provides no recovery, override or reset for it. Protection is a guard on the interface rather than encryption, so it was never a confidentiality control — but nothing in the product removes it without the password either |
Frequently asked questions
How can I tell whether a protected sheet even has a password?
Click Review > Unprotect Sheet and watch what happens. If protection lifts with no dialog, no password was ever set — the field in Protect Sheet is optional and plenty of people leave it blank to guard against accidents rather than people. A password prompt means one was set, and only that exact string will lift it.
Why is Unprotect Sheet greyed out, or still showing as Protect Sheet?
Because that sheet is not protected, so whatever is stopping you is something else. The usual candidates are Protected View on a downloaded file, shown by a yellow bar offering Enable Editing; a read-only or Mark as Final workbook; or workbook-structure protection, which locks the sheet tabs rather than the cells.
Does unprotecting a sheet unlock its cells?
No, and this trips people up. Locking and protection are two halves of one mechanism: the Locked flag in Format Cells marks a cell, and sheet protection is what enforces the mark. Unprotecting stops the enforcement without clearing any flags, so switching protection back on restricts precisely the same cells again.
Can I unprotect every sheet in a workbook at once?
No. Unprotect Sheet acts on the active worksheet alone, so a workbook with twelve protected sheets needs twelve trips through the Review tab even when the same password was used throughout. Selecting several tabs first does not extend the command across them.
New guides and tools, once a month
DE + EN · double opt-in · no spam