How to Unprotect an Excel Sheet With or Without a Password

Picture a shared budget where every cell refuses to change the moment you type. Excel protection works like a locked desk drawer: it keeps accidental edits out, but it doesn’t mean the contents are off-limits.

Unprotecting an Excel sheet is simpler than it looks. If you know the password, it takes just a few keystrokes. If you don’t, you still have options, but they depend on how the protection was applied.

In this post, we’ll sort out the difference between sheet, workbook, and file protection, walk through the keyboard route on Windows and Mac, and cover the no-password options for when the password is lost.

Excel Protection Basics and How to Unprotect

Before you remove anything, it helps to know why a sheet is locked and which cells you actually need to edit. Here’s the short version of both.

Why you would protect an Excel file

You’ll usually turn on sheet protection for one of two reasons:

• Prevent unwanted changes by others. A shared file is easy to damage. One stray keystroke can overwrite a formula or delete a row before anyone notices.
• Avoid storing confidential information. If a sheet holds sensitive details, the safest choice is to keep them out of the file altogether.

Consider a home office bookkeeper who emails a monthly budget to a client. With the totals protected, the client can type in their own numbers without breaking the formulas, and the bookkeeper gets back a clean file every time. Your formulas stay put.

The aim is to keep a sheet stable rather than secret.

Unlock single cells within a protected sheet

Any cell people should be able to edit needs to be unlocked first. Here’s how:

1. Select the cell you want people to edit.
2. Press Ctrl+1 (the correct shortcut here, not Ctrl+2) to open Format Cells.
3. Clear the Locked box, then click OK.

That’s it. The cell you unlocked stays open for editing while the rest of the sheet stays protected.

Unprotect a Sheet Using a Known Password

If you know the password, unprotecting a sheet takes only a few clicks. Here, we’ll focus on sheet protection, which locks cells on a single worksheet.

It’s different from workbook protection, which guards the file’s structure, and from file protection, which controls who can open the file at all.

Follow the standard steps to unprotect

Here’s the standard route:

1. Open the protected Excel file.
2. Select the Review tab.
3. In the Protect group, click Unprotect Sheet.
4. Enter the password, then click OK.
5. Edit the worksheet as needed. Every cell is open to change again.

Prefer the keyboard? On Windows, press Alt, then R, P, and S. Each letter opens the next step: the Review tab, the Protect group, then Unprotect Sheet. Type the password and press Enter, and your hands never leave the keys.

Consider a freelance bookkeeper working from a home office who receives a client’s invoice template with the formulas locked.

With the password the client sent, she unprotects the sheet, updates the tax rate in one cell, and returns the file before lunch, with no waiting on the client’s IT contact. That’s the whole fix.

Here’s how the two platforms line up:

Step	Windows	Mac
Find the command	Review tab, Protect group	Review tab
Unprotect	Click Unprotect Sheet	Click Unprotect Sheet
Password	Enter itthenclick OK	Enter itthenclick OK

The keyboard route is the Windows sequence, so Mac users should stick with the mouse steps in the Mac column.

Options for Unprotecting Without a Password

Forgot the password, or inherited a locked sheet from a colleague who’s since moved on? You have a few ways in without it, from a macro to a browser workaround to a zip and XML edit for the most hands-on approach.

Unlocking the sheet with a VBA macro

Consider a home office bookkeeper who inherits a budget workbook from a retired colleague. The forecast tab is locked, and nobody remembers the password.

Her first move is a VBA (Visual Basic for Applications) macro, the scripting language built into Excel.

1. Save the file in a different format first.
2. Open the Visual Basic Editor by pressing Alt+F11.
3. Insert a module, then paste in the VBA code.
4. Run the code to reveal the password.

The payoff is recovering the forecast she already has, rather than rebuilding it from scratch. Work on a copy, always.

Try a Google Sheets upload workaround

If the macro feels like too much, a browser route takes three steps and no code:

• Upload the file to Google Drive.
• Open it with Google Sheets.
• Download it again as XLSX, the standard Excel workbook format.

Then open the new copy and see what’s still locked.

The zip and XML edit method is the most hands-on option. Instead of working through Excel’s menus, you edit the XML (Extensible Markup Language) that makes up the file’s contents.

It suits people already comfortable with that kind of editing, and it’s worth keeping a backup before you start.

Protection is a guardrail, not a wall. Knowing which type you’re dealing with tells you where to start, and the keyboard steps keep your hands on the keys.

With the password, you’ll be editing in seconds. Without it, the no-password options offer a real path forward, as long as you have permission to change the file.

A locked sheet is rarely a dead end. It just needs the right key.