If you need to unprotect an Excel sheet, the fastest path is usually straightforward: open the workbook, go to Review, choose Unprotect Sheet, and enter the password if the sheet was protected with one. If you already have authorization to edit the file, that’s all it takes.
If you’re actually trying to lock the file back down afterward, see Excel Workbook Protection. That post covers the difference between sheet protection and workbook structure protection, which is important because Excel has more than one protection layer.
Sourced stat: Microsoft’s Protection and security in Excel article was last updated on 2025-10-17 and documents 4 ways to protect Excel work: password to open, Read-Only access, worksheet protection, and workbook structure protection.
Quick Answer
To unprotect an Excel sheet, use Review -> Unprotect Sheet and enter the password. If the sheet is part of a protected workbook, remove workbook structure protection first. If you do not know the password, use version history, a backup, or the workbook owner’s help instead of trying to bypass the lock.
What “Unprotect” Actually Means in Excel
Excel protection gets confusing because people often say “protect the file” when they mean one of three different things:
| Layer | What it controls | What you do |
|---|---|---|
| Sheet protection | Locked cells, formulas, objects, and allowed edits | Use Review -> Protect Sheet or Unprotect Sheet |
| Workbook protection | Sheet structure, like adding, deleting, renaming, or moving tabs | Use Review -> Protect Workbook |
| File encryption | Who can open the workbook at all | Use a password to open the file |
That distinction matters because removing one layer does not automatically remove the others. A workbook can be unprotected at the sheet level and still keep its structure locked. Likewise, a sheet can be editable while the file still requires a password to open.
How to Unprotect an Excel Sheet Step by Step
If you know the password, unprotecting a worksheet is usually a short, 1-minute job. Open the protected sheet, go to Review, choose Unprotect Sheet, and enter the password when Excel asks for it. That’s the normal path for legitimate editing, and it works the same way on most desktop versions.
1) Open the workbook and select the locked sheet
Start with the worksheet you want to edit. If the workbook contains several tabs, make sure you’re on the specific sheet that is protected. Excel only applies the command to the active sheet unless you’ve built automation around it.
2) Go to the Review tab
On the ribbon, open Review. That is where Excel places the protection tools for both worksheets and workbook structure. In most desktop versions of Excel for Windows and Mac, the command label is the same.
3) Click Unprotect Sheet
If the sheet is protected, Excel will show Unprotect Sheet instead of Protect Sheet. Click it.
- If no password was used, the sheet unlocks immediately.
- If a password was set, Excel prompts you to enter it.
That password prompt is the normal, intended route. If you know the password, this is the cleanest possible workflow.
4) Enter the password and confirm
Type the password exactly as it was set, including capitalization. Excel passwords are case-sensitive. After you confirm, the sheet becomes editable again.
5) Save the workbook if you want the unlocked state to persist
If you want the file to remain unprotected after closing it, save the workbook after unprotecting. Otherwise, you may open a newer copy later that still has the original protection settings.
If the Workbook Structure Is Protected Too
Sometimes people unprotect a sheet and still can’t add, delete, or rename tabs. That usually means the workbook structure itself is protected.
If that happens, go back to Review -> Protect Workbook and remove the workbook password first. Workbook protection is a separate layer, so sheet protection alone won’t fully restore tab-level control.
This is where the Excel Workbook Protection article is useful. It explains why Excel can lock the workbook structure even when the sheet itself looks editable.
If You Forgot the Password
If you own the file but lost the password, the safest legitimate options are limited but effective:
- Check version history in OneDrive or SharePoint if the file is stored there.
- Restore a backup copy if you keep local backups or synced copies.
- Ask the workbook owner for the password or for an unlocked copy.
- Rebuild from the source data if the workbook is disposable and the important data lives elsewhere.
I would not recommend ZIP tricks, password crackers, or other bypass methods. They are brittle, they can damage files, and they are the wrong choice for shared or third-party workbooks. If the file is not yours, the right path is permission, not bypass.
Legitimate VBA Automation for Your Own Workbooks
If you manage your own workbook and already know the password, VBA can unprotect a sheet in bulk. That can be useful in internal automation, template refreshes, or controlled admin workflows.
Sub UnprotectActiveSheet()
ActiveSheet.Unprotect Password:="your_password_here"
End SubA few practical notes:
- This only works when you already know the password.
- It is best used on files you own or are explicitly authorized to manage.
- If you need to re-protect the sheet later, use the matching
Protectmethod and keep the permissions tight.
If you’re automating a lot of sheets, it’s usually better to build a consistent protect/unprotect routine than to manually toggle protection one tab at a time.
Best Practices After You Unprotect a Sheet
Unprotecting is only half the job. Once the sheet is editable, it’s easy to make accidental changes that ripple through formulas, charts, or downstream reports. I usually treat this as a 3-step cleanup: edit quickly, re-lock narrowly, and verify the key formulas before sharing the file again.
Keep a clean edit window
Make your edits in one pass if possible. The longer a sheet stays unlocked, the more chance someone has to change a formula or overwrite a locked-in value.
Re-protect only the cells that need it
If only a small input area should remain editable, unlock those cells and protect the rest of the sheet again. That gives you a better balance between flexibility and control.
Document the change
If you’re working in a team, leave a short note about what changed and when. A simple comment in the file or a version-history note can save a lot of time during review.
Double-check formulas and references
Unprotecting itself does not alter formulas, but editing while the sheet is open absolutely can. After you finish, scan the key totals, links, and lookup formulas before you hand the file back.
When Unprotect Sheet Is Greyed Out or Missing
If Excel does not show Unprotect Sheet, the problem is usually one of four things. The fix is rarely mysterious: check the active tab, check workbook structure protection, check whether the file is read-only, and check whether you are in the desktop app instead of a limited viewer.
1) You’re on the wrong tab
The command only applies to the active worksheet. If you need to edit a different tab, click that sheet first and check the Review tab again. In a workbook with 5 or 20 tabs, it is easy to unlock the wrong one and wonder why nothing changed.
2) Workbook structure protection is still on
If the workbook structure is locked, Excel may allow certain sheet edits but still block tab-level actions. In that case, go to Review -> Protect Workbook and remove the structure password first. Think of this as the second layer of protection: the sheet may be open, but the workbook shell can still be closed.
3) The file is read-only or cloud-locked
A workbook stored in SharePoint, OneDrive, or a network folder can be opened in read-only mode if another user already has it locked or if your permissions are limited. You can still view the file, but you may not be able to change the protection state. Save a local copy or use version history if you are authorized to do so.
4) You’re in a limited app view
Excel for the web, mobile Excel, or a viewer-style app may not expose every protection command. If the ribbon is missing the command you need, open the workbook in the desktop app. The full desktop version is usually the safest place to manage protection settings.
How to Rebuild a Safer Sheet After Editing
Sometimes the best workflow is not to leave the sheet unprotected at all. If you only needed to edit a few cells, unlock the minimum amount of space and then protect the sheet again. That keeps the workbook useful for the next person without turning it into an open target.
A simple 4-step pattern
- Unlock only the input cells you want people to edit.
- Protect the sheet from the Review tab.
- Allow only the actions you actually need, such as selecting unlocked cells or sorting.
- Test the sheet with a dummy entry before you hand it back.
That pattern gives you flexibility without turning the whole workbook into an open target. For finance models, reporting templates, and shared trackers, that usually matters more than leaving everything editable.
The permission checklist I use
When I re-protect a worksheet, I usually ask 5 questions:
- Do users need to select locked cells?
- Should they be able to format cells?
- Do they need to insert rows or columns?
- Is sorting allowed?
- Are filters supposed to stay usable?
Those 5 questions tell you whether the sheet is genuinely usable or just technically protected. If the answer to every question is no, the sheet may be secure but not practical. If the answer to all five is yes, the protection is probably too loose.
When Unprotecting Is the Wrong Fix
There are a few cases where the sheet is locked for a reason and unprotecting is not the right first move. In those cases, the better question is whether you need a wider edit window or just a few more allowed actions, because that is usually the safer 1-minute adjustment.
- Shared templates: the protection may be there to preserve formatting or formulas.
- Financial models: locked cells may prevent accidental damage to critical calculations.
- Distribution copies: the workbook owner may want to keep structure locked while still allowing data entry.
In those cases, ask whether you really need to remove protection or whether you only need a few input cells unlocked. Often the better fix is to adjust permissions, not remove them entirely.
A Practical Note on Passwords
Excel passwords are case-sensitive, and that catches people more often than they expect. A password that looks right on paper can still fail because of caps lock, a trailing space, or a different keyboard layout. If you are certain you own the file but the password is not working, slow down and try the exact saved version of the password before assuming the workbook is corrupted.
If you are working from a shared team file, it is also worth checking whether the password has changed since the last revision. In teams that rotate templates, it is common for the protection password to be updated when the workbook structure changes. That means the right password may be in an email thread, a project note, or a handoff doc rather than in the file itself.
Conclusion
To unprotect an Excel sheet, use Review -> Unprotect Sheet and enter the password if prompted. If workbook structure protection is also enabled, remove that separately. If you forgot the password, rely on version history, backups, or the workbook owner’s help.
For related reading, the companion guide on Excel Workbook Protection explains the other half of Excel’s security model and helps you decide whether you need to unlock the sheet, the workbook structure, or the file itself. If you are building a reusable template, lock it back down before you share it.
FAQs
How do I unprotect an Excel sheet if I know the password?
Use Review -> Unprotect Sheet, type the password, and confirm. It is usually a 3-click workflow: Review, Unprotect Sheet, password entry.
What if the workbook is protected too?
Then you are dealing with 2 layers of protection. Remove workbook structure protection first, then unprotect the sheet if needed.
Can I unprotect a sheet without changing the formulas?
Yes. Unprotecting does not automatically change formulas. It simply turns editing back on for cells that were locked or otherwise restricted.
Is there a safe way to recover a lost password?
Yes: use version history or a backup copy first. Those are the 2 safest legitimate recovery paths for files you own.
Can I protect the sheet again after editing?
Yes. Reapply protection when you are done. If you need a simple rule of thumb, spend 1 minute re-locking the workbook instead of leaving it open-ended.
