How to Unprotect an Excel Sheet (With or Without the Password)

You open a spreadsheet to fix one number and Excel refuses to let you type. Nine times out of ten that's sheet protection, switched on by whoever built the file, and it's often a template a colleague or an old client set up years ago.

I'll walk you through switching it off in Excel for Windows, Excel for Mac and Excel for the web, then cover the bit that trips most people up: what you can and can't do when nobody remembers the password.

Signs your Excel sheet is protected

A protected sheet looks normal until you try to change something. You'll usually see a message saying the cell is on a protected sheet, or the ribbon buttons for formatting and inserting rows will be greyed out. The quickest check is the Review tab: if the button reads Unprotect Sheet rather than Protect Sheet, protection is on for the sheet you're looking at.

Remember that protection is set sheet by sheet. One tab in a workbook can be locked while the next one is wide open, so check the tab you're working on rather than the first one that opens.

Unprotecting an Excel sheet in Excel for Windows

Microsoft gives two routes on Windows, and they both land in the same place.

1. Go to the worksheet you want to change.
2. Select Review, then in the Changes group select Unprotect Sheet. Or use File, then Info, then Protect, then Unprotect Sheet.
3. If the sheet has a password, type it into the Unprotect Sheet box and select OK.
4. Try editing a cell. If it now lets you type, you're done.

If there's no password, the protection simply comes off the moment you select Unprotect Sheet. There's no extra confirmation.

Unprotecting an Excel sheet on a Mac

1. Select the protected sheet tab at the bottom of the window.
2. Open the Review tab and click Unprotect Sheet.
3. Enter the password if Excel asks for one.

One Mac quirk is worth knowing. Microsoft says passwords in Excel for Mac have a 15-character limit, and a file protected on Windows with a longer password can't be opened in Mac Office. If that's your problem, ask the person who made the file on Windows to shorten it.

Unprotecting a sheet in Excel for the web

The browser version works a little differently, and it gives you an option the desktop apps don't.

1. Open the workbook in Excel for the web.
2. Select Review, then Manage Protection.
3. In the pane that opens, turn off Protect sheet.

If you only need to make a quick change, select Review, then Pause Protection instead. Microsoft says that suspends protection for your current session only, and Resume Protection switches it back on. You'll still need the password to pause it if the sheet has one. I like this for shared team files, because you can't forget to put the protection back.

Unprotecting an Excel sheet when you don't have the password

Here's the plain truth from Microsoft's help page: if you forget your password, Microsoft can't retrieve it. There's no reset link and no support form that opens it up for you. Microsoft's Mac page says that if you lose the password, you can't access the protected parts of the sheet.

I won't point you to password-cracking tools or downloads that claim to strip protection. They're a risk to your computer and often to your client's data. Here's what I'd do instead, in this order:

1. Ask the person who created the file. It's often a colleague, a former bookkeeper or an agency, and they may have it written down.
2. Look for an older copy of the file in your email, shared drive or backups that was saved before protection went on.
3. Check whether the sheet even has a password. Select Unprotect Sheet first: if no box appears, it comes straight off.
4. If you're allowed to select cells, you can often copy the values you need into a new workbook and rebuild from there.

That last one only works if the creator allowed people to select locked cells when they set up protection. If they didn't, you'll need the creator.

Sheet protection versus workbook protection in Excel

People often unprotect the sheet and then wonder why they still can't add or rename tabs. That's a separate lock on the workbook structure.

What's locked	What it stops	How to switch it off
Sheet protection	Editing locked cells on one tab	Review, Unprotect Sheet
Workbook structure	Adding, moving, deleting, hiding or renaming sheets	Review, Protect Workbook, enter the password, OK
File password	Opening or changing the file at all	Handled from File, Info in the desktop app

Microsoft notes that Excel for the web can open password-protected workbooks but can't add, change, remove or recover those passwords. If you need to change one, select Open in Excel and do it in the desktop app.

Why Excel sheet protection isn't security

This is the bit I'd want every small business owner to know. Microsoft says worksheet-level protection isn't intended as a security feature. It's there to stop people overwriting formulas by accident, not to keep anything private.

So if you're sending a quote calculator or a client tracker, don't rely on sheet protection to hide what's inside. If a file needs to stay private, keep it to the people who need it. And if your team mostly works in the browser, it's worth knowing how the same jobs work in Google, such as adding tick boxes to a shared Google Sheet for a simple task list.

Putting protection back on your Excel sheet

Once you've made your change, it's good manners to lock the template again if others rely on it. Go back to Review and select Protect Sheet, choose what people can still do, and add a password if you want one.

Microsoft suggests passwords of 8 or more characters, and says a passphrase of 14 or more characters is better. Write it down somewhere safe, because the same rule applies: if it's lost, it's lost. If you're building a stock or order tracker that others will fill in, my walkthrough of totting up a column in Google Sheets covers the formulas you'll most likely want to protect.

Frequently asked questions

How do I unprotect an Excel sheet without the password?

Microsoft says it can't retrieve a forgotten password. Your options are to ask the person who created the file, find an older unprotected copy, or copy the values you can still select into a new workbook.

Why is Unprotect Sheet greyed out or missing?

Check you're on the right tab, because protection is set per sheet. If the button says Protect Sheet, that sheet isn't protected and the lock you're hitting may be the workbook structure instead.

Can I unprotect a sheet in Excel for the web?

Yes. Select Review, then Manage Protection, and turn off Protect sheet. You can also use Pause Protection to switch it off for your current session only.

Does unprotecting a sheet remove protection from the whole workbook?

No. Sheet protection and workbook structure protection are separate. To free up the structure, select Review, then Protect Workbook, and enter its password.

Is an Excel sheet password case-sensitive?

Yes. Microsoft says passwords are case-sensitive, so check that Caps Lock is off before you type it.