How to Password Protect an Excel File: 6 Easy Steps

To password protect an Excel file, open your workbook and click File > Info > Protect Workbook > Encrypt with Password. Type a password, confirm it, and save. On Mac, go to File > Passwords instead. Modern Excel then encrypts the file with AES-256, so nobody can open it without your password.

Let me guess. You've got a spreadsheet full of salaries, client details, or bank numbers, and it's just sitting there. Unprotected. Yikes.

I've seen this go wrong, and it's not fun. The good news? You can fix it in under a minute. Below, I'll show you exactly what to click, which method fits your situation, and what to avoid. Let's dive in.

Why You Should Password Protect Your Excel Files

Spreadsheets get emailed, shared, and copied to USB sticks constantly. One wrong click and your private data lands in the wrong inbox. That's a headache you can avoid.

A password protected Excel file puts a real barrier between your data and curious eyes. It takes seconds. It costs nothing extra if you already own Excel.

If you handle client or company data, it also pays to understand data loss prevention software, which helps secure business data, support compliance, and catch insider threats.

One caution, though. Microsoft warns that a password doesn't automatically stop someone with bad intentions. So think of it as a strong lock, not a magic shield.

Excel's Three Protection Levels Compared

Before you click anything, you need to know that Excel has three kinds of protection, not one. Mixing them up is the most common mistake I see.

Think of a house. You've got the front door, the rooms inside, and the cabinets. Each needs a different key. Microsoft explains the differences clearly, and here's my quick summary:

Protection typeWhat it doesEncrypts the file?Best forFile encryption (password to open)Blocks anyone from opening the fileYes (AES)Sensitive data, sharing filesWorkbook structure protectionStops adding, deleting, renaming, or unhiding sheetsNoFinished reportsWorksheet protectionLocks cells, formulas, and formattingNoPreventing accidental editsPassword to modifyAllows reading, but saving changes needs a passwordNoView only sharing

Here's the catch. Microsoft states that worksheet level protection isn't intended as a security feature. Use it to prevent accidents, not to guard secrets.

How to Encrypt an Excel File on Windows

This takes about 30 seconds. Open your workbook first, then follow these steps, exactly as Microsoft lays them out:

Click File, then Info.
Select Protect Workbook.
Choose Encrypt with Password.
Type your password and click OK.
Reenter it to confirm.
Save the file.

Done. Next time you open it, Excel asks for the password.

Pick a Strong Password

Make it long. A random phrase of several words beats a short, clever one. Passwords are also case sensitive, so capitals matter.

Write it in a password manager before you hit Save. That one habit will save you later.

How to Password Protect an Excel File on Mac

Mac users, the menu looks different, and that confuses plenty of people. In one Microsoft Q&A thread, a user couldn't find "Info" because it doesn't exist in that version.

Go to File > Passwords instead. Enter a password to open, and optionally a password to modify. Click OK, reenter each one, and save.

What About Excel for the Web?

Here's a surprise. Excel for the web can't encrypt a workbook. You can set read only mode, but that's it.

Want real encryption? Select Editing > Open in Desktop App, then follow the Windows steps.

PlatformWhere to find itEncryption available?WindowsFile > Info > Protect WorkbookYesMacFile > PasswordsYesExcel for the webNot available (open in desktop app)No

Password to Open vs. Password to Modify

Excel gives you two different passwords, and they do very different jobs.

A password to open locks the whole file. Without it, nobody gets in.

A password to modify is softer. People can still open and read the file, but they need the password to save changes. It doesn't encrypt anything.

The Technical Facts (Why AES-256 Matters)

If you like numbers, here they are. According to Elcomsoft's security research, a password to open on a modern Microsoft 365 file uses AES with a 256 bit key, a key derived through 100,000 iterations of SHA-512, and a 16 byte salt.

Older formats were far weaker. The same research notes that early Office encryption used XOR, which is obfuscation rather than real encryption. It also found that Microsoft later moved to AES-128 with 50,000 SHA-1 iterations.

Modify passwords and sheet protection don't get that treatment. According to the same source, they don't touch encryption at all, so password length is irrelevant for them.

My advice? Use the open password for anything sensitive. Add the modify password only when you want others to view but not edit.

How to Protect Workbook Structure and Lock Cells

Sometimes you don't need to lock the file. You just want to stop people from messing up your layout or formulas.

To protect the workbook structure, click Review > Protect Workbook. That blocks inserting, deleting, renaming, moving, and hiding sheets.

To protect cells, first lock the cells you want safe, then use Review > Protect Sheet. You can also unlock specific ranges for people to edit.

How to Remove a Password from an Excel File

Changed your mind? Removing it is easy, as long as you know the current password.

Michigan's IT team describes the process this way: open the file, go to File > Info > Protect Workbook > Encrypt with Password, clear the password box, click OK, and save.

What Happens If You Forget Your Password?

Take a deep breath, because this is the scary part. If you lose it, Microsoft can't retrieve it for you.

A Microsoft Q&A answer confirms there's no built in recovery for a fully encrypted file. Your best hope is an unprotected backup, or a previous version on OneDrive or SharePoint.

So, here's what I do. I keep every password in a secure vault, like the encrypted password management covered in this BUNKR digital security guide. I also never email the password with the file. Brown University's IT team gives the same advice: share it through a different channel.

Why Microsoft 365 Is Worth Every Penny

Let me be straight with you. Real file encryption lives in the desktop app. The web version can't do it.

That's why I recommend Microsoft 365. You get desktop Excel with encryption, workbook protection, and sheet protection in one place.

Think about what's at stake. One leaked spreadsheet can cost you clients, money, or your reputation. Compare that to a subscription fee. It's a no brainer.

Plus, cloud storage with version history can rescue you if a password ever goes missing. That's peace of mind you can't put a price on.

Frequently Asked Questions

How do I password protect an Excel file?

Go to File > Info > Protect Workbook > Encrypt with Password, enter a password, confirm it, and save. On Mac, use File > Passwords.

Does Excel password protection use encryption?

Yes, but only the password to open. Modern files use AES-256. Sheet protection and modify passwords don't encrypt the file.

Can Microsoft recover a forgotten Excel password?

No. Microsoft says it can't retrieve lost passwords. Check for backups or earlier versions on OneDrive or SharePoint.

Can I password protect an Excel file in Excel for the web?

Not directly. Open the file in the desktop app, then encrypt it there.

What's the difference between protecting a sheet and a workbook?

Sheet protection controls what people can change inside one worksheet. Workbook protection controls the structure, like adding, deleting, or renaming sheets.

Is a password protected Excel file completely safe?

It's strong, but not unbreakable. A long, random password to open makes the file very hard to attack, while weak passwords and sheet level protection offer much less security.

Final Thoughts: Lock It Down Today

You now know how to password protect an Excel file on Windows, Mac, and the web. You also know which protection level does what.

So don't wait. Open that sensitive spreadsheet, click Encrypt with Password, and save it. It takes less time than making coffee.

And if you don't have the desktop app yet, get Microsoft 365 and protect your data properly.