How to Unlock an Excel Spreadsheet: A Complete Step-by-Step Guide

You go to update a spreadsheet maybe one you built months ago, or one you inherited from a former teammate and Excel stops you cold with a "this cell is protected" message. If you set the protection yourself, unlocking it takes about ten seconds. If you didn't, or you've simply forgotten the password, it takes a bit more work, but it's still very doable.

This guide covers both situations: removing protection when you know the password, and what your options are when you don't.

Before anything else, a quick note: only remove protection from files you own or have explicit permission to modify. Excel's protection features are designed to prevent accidental edits and support controlled collaboration, not to serve as strong security but working around them on someone else's file without authorization can violate company policy, so make sure you're clear to proceed.

Understanding What's Locked

Excel protection isn't one setting it's a stack, and knowing which layer you're dealing with determines which fix you need:

• Sheet protection blocks editing of cells, formulas, and formatting on a specific worksheet tab.
• Workbook structure protection prevents adding, deleting, renaming, or reordering sheet tabs.
• File encryption (open password) requires a password just to open the file at all.

The method for unlocking depends on which one you're up against.

Method 1: Unprotect a Sheet (When You Know the Password)

This is the most common scenario — you or a colleague protected the sheet, and the password is known or written down somewhere.

1. Go to the Review tab on the ribbon.
2. Click Unprotect Sheet.
3. Enter the password when prompted.
4. Click OK.

The sheet is now fully editable again. If no password was ever set, clicking Unprotect Sheet removes protection immediately with no prompt at all.

Method 2: Remove Workbook Structure Protection

If tabs are grayed out  you can't add, delete, or rename sheets the workbook structure itself is protected, which is a separate setting from sheet protection.

1. Go to the Review tab.
2. Click Protect Workbook (it will appear highlighted/active if protection is on).
3. Enter the password if one was set.
4. Click OK to remove protection.

Method 3: Remove File Encryption (Open Password)

If Excel asks for a password before the file will even open, that's file-level encryption rather than sheet protection.

1. Open the file with the correct password.
2. Go to File > Info > Protect Workbook > Encrypt with Password.
3. Clear out the password field so it's blank.
4. Click OK and save the file.

The file will now open without a password the next time it's used.

What If You've Forgotten the Password?

This is where things split depending on which type of protection you're dealing with.

For sheet protection (not file-open passwords):

Sheet protection uses a much simpler mechanism than file encryption, and modern .xlsx files are actually structured as a collection of zipped XML files behind the scenes. This means that, for a file you own, it's often possible to remove sheet protection without the original password by working directly with the file's internal structure — extracting the archive, editing the protection reference in the worksheet's XML, and resaving. It's a fiddly, technical process, and it's easy to corrupt the file if a step goes wrong, so always work on a copy, never the original.

If that sounds more technical than you'd like to tackle, a reputable spreadsheet-recovery tool or your organization's IT team can usually handle it faster and more safely.

For file-open (encryption) passwords:

This is a different story. File-level encryption in modern Excel uses strong encryption (AES-128 or better), and there's no simple workaround if the password is genuinely lost — Microsoft does not offer password recovery for encrypted files. Your realistic options are:

• Check whether the file was backed up or version-historied somewhere (cloud storage like OneDrive or Google Drive often keeps prior versions).
• Ask whoever created or last saved the file if they remember the password or have it stored in a password manager.
• If it's a work file, check with your IT or security team — company policy may require passwords to be escrowed for exactly this situation.

There's no reliable, safe shortcut here, which is exactly why file encryption is the right layer to reach for when data genuinely needs to stay private — it's meant to be difficult to bypass.

Preventing This Next Time

A little bit of setup now saves a lot of frustration later:

• Store passwords somewhere retrievable, like a password manager, rather than only in your memory or a sticky note.
• Keep an unprotected master copy of important templates in a separate, secure location, so you always have a fallback.
• Use sheet protection for structure, not secrecy. If the goal is just to stop accidental edits (not hide sensitive data), skip the password entirely — anyone can still remove protection through the Review tab, but it prevents the everyday "oops, I typed over a formula" moment.
• Reserve file encryption for genuinely sensitive data, and make sure the password is documented somewhere your team can access if needed.

FAQs

Why does Excel say a sheet is protected even though I never set a password? Sheet protection can be turned on without a password. In that case, go to Review > Unprotect Sheet — it will unlock immediately with no prompt.

Can I unlock an Excel file without knowing the password at all? For sheet protection, yes, there are technical workarounds involving the file's internal structure, though they take some care. For file-open encryption, no — there's no built-in recovery, so prevention (storing your passwords securely) matters far more than a fix after the fact.

Is it legal to remove password protection from a spreadsheet? Removing protection from a file you own, or one you're authorized to modify, is fine. Removing it from someone else's protected file without permission can violate company policy or, in some cases, the law — always confirm you have the right to make the change.

Does unprotecting a sheet delete any data? No. Unprotecting a sheet only changes what can be edited going forward; it doesn't touch the data or formulas already in the cells.

What's the difference between "unprotect" and "decrypt" in Excel? Unprotecting removes edit restrictions on a sheet or workbook that's already open. Decrypting removes the password required to open the file in the first place — they're separate settings handled in different places.

Bringing It All Together

Most of the time, unlocking an Excel spreadsheet is a two-click fix: Review tab, Unprotect Sheet, enter the password. The trickier cases — forgotten passwords, encrypted files — are rare enough that it's worth spending a few minutes upfront preventing them, rather than troubleshooting them after the fact.

If you're rebuilding a spreadsheet from scratch after a protection headache, or just want a clean, protection-ready starting point, ThePlanwise's budget and planning templates come pre-built with formulas locked sensibly from the start, so you can focus on using the spreadsheet instead of fighting with it.

---

Browse ThePlanwise's collection of spreadsheets, planners, and productivity templates — thoughtfully built so protection never gets in your way.