How to Password-Protect an Excel File

An Excel file can hold a surprising amount of sensitive information: payroll figures, customer lists, pricing models, budgets, and personal finance trackers. Yet most workbooks are shared by email and shared drives with no protection at all, meaning anyone who gets the file can open it, read everything, and pass it on.

Excel gives you several kinds of protection, and they are not interchangeable. A password to open encrypts the file and keeps outsiders out. A password to modify lets people view but not save changes. Sheet protection stops edits to formulas or tabs, but it is not real security.

This guide explains each option honestly, shows you the exact steps to add a password to open an Excel file on Windows and Mac, and covers what to do about storing the password safely and what happens if it is forgotten.

Quick Answer

To password-protect an Excel file so it cannot be opened without the password, go to File > Info > Protect Workbook > Encrypt with Password, enter a strong password, confirm it, and save the file. Anyone opening the file after that must enter the password first. Store the password in a password manager, because Microsoft cannot recover it if you forget it.

Know the Three Levels of Excel Protection

Before following any steps, decide what you are actually trying to prevent, because the right tool depends on the threat.

Password to Open (Real Encryption)

This is the only option in this list that truly secures the contents. The file is encrypted, and without the password the data inside cannot be read at all, even with specialist tools within any reasonable effort for a strong password. Use this for confidential files leaving your control: email attachments, files on shared drives, and anything containing personal or financial data.

Password to Modify

This lets anyone open and read the file, but they need the password to save changes to the original. Without it, they can open the file as read-only and save a copy under a different name. This is useful for master templates and official price lists where visibility is fine but the source file must not be altered.

Sheet and Workbook Protection

Review > Protect Sheet and Review > Protect Workbook prevent editing of cells, formulas, or sheet structure. They guard against accidental changes, but they do not encrypt anything. Use them alongside a password to open, not instead of one.

Method 1: Encrypt With a Password From File > Info

This is the standard method on Windows and the one Microsoft recommends for securing a workbook.

1. Open the workbook you want to protect and save any pending edits.
2. Click File in the top-left corner to open the Backstage view.
3. Click Info in the left menu if it is not already selected.
4. Click the Protect Workbook button.
5. Choose Encrypt with Password from the drop-down menu.
6. Type your password in the Encrypt Document dialog box and click OK.
7. Type the exact same password again in the Confirm Password dialog and click OK.
8. Press Ctrl + S to save the file. The password only takes effect once the file is saved.
9. Close the file completely, then reopen it. Excel should ask for the password before showing any data. If it does, the protection is working.

The Info screen will now show that a password is required to open this workbook. See also Microsoft Support for protecting an Excel file for version-specific notes.

Method 2: Set the Password From Save As Options

The Save As dialog has a lesser-known General Options screen that lets you set both a password to open and a password to modify in one place. This is the method to use when you specifically want the modify password as well.

1. With the workbook open, click File > Save As and choose the location for the protected copy.
2. In the Save As dialog, click Tools next to the Save button. On some versions this appears as a small drop-down at the bottom of the dialog.
3. Choose General Options.
4. Enter a password in the Password to open box if you want encryption.
5. Enter a password in the Password to modify box if you want to control who can save changes.
6. Optionally tick Read-only recommended if you want Excel to suggest read-only opening even to people with the modify password.
7. Click OK, confirm each password when prompted, then click Save.

Using Save As like this also gives you a sensible workflow: keep an unprotected master copy in a secure location and share only the protected copy. If you ever forget the shared password, your master copy saves the day.

How to Do It on Excel for Mac

The Mac version reaches the same result through a slightly different menu path:

1. Open the workbook in Excel for Mac.
2. Go to File > Set Passwords… in the menu bar. In some versions the option is under File > Passwords.
3. Enter a Password to open and/or a Password to modify in the File Passwords dialog.
4. Click OK and re-enter the passwords to confirm them.
5. Save the file with Cmd + S, then close and reopen it to test the prompt.

Files protected this way open normally on Windows and vice versa with a current version of Excel. For sensitive data, make sure the file was last saved by a modern version, which uses strong AES encryption.

Choosing a Password That Actually Protects You

Encryption is only as strong as the password guarding it. A workbook encrypted with the password “1234” or the company name is protected in name only. Follow these rules:

• Use at least 12 characters, mixing upper and lower case letters, numbers, and a symbol or two.
• Use a phrase you can remember but others cannot guess, rather than a single dictionary word.
• Never reuse your email, banking, or Windows login password for a file password.
• Do not use the business name, a project name, a birthday, or anything printed inside the spreadsheet itself.
• Share the password through a different channel from the file. If you email the workbook, send the password by text message or phone call, never in the same email thread.

Store the password in a reputable password manager. Teams should agree one place where file passwords are recorded, so a colleague leaving does not take the only copy with them.

How to Remove or Change the Password

Removing protection is simple when you know the password, which is exactly how it should be:

1. Open the file by entering the current password.
2. Go to File > Info > Protect Workbook > Encrypt with Password.
3. The dialog will show a row of dots representing the current password. Delete them so the box is completely empty.
4. Click OK and save the file. It will now open without a prompt.
5. To change the password instead, type the new password in that same box, click OK, confirm it, and save.

For more spreadsheet and Office walkthroughs of this kind, browse NetworkUstad’s software how-to guides, which cover Excel, Word, and Windows tasks step by step.

Common Mistakes to Avoid

• Not saving after setting the password: The encryption is only written to the file when you save. Set the password, save, close, and reopen to test, every time.
• Confusing sheet protection with file encryption: Protect Sheet stops edits; it does not hide data. If the file is confidential, you need Encrypt with Password.
• Forgetting the password has no recovery option: Microsoft cannot unlock the file for you, and neither can IT support. Legitimate recovery tools work by guessing, which fails against strong passwords. Keep a record in a password manager.
• Sending the password with the file: An encrypted attachment and its password in the same email offer almost no protection if the mailbox is compromised.
• Using one password for every file forever: If that password leaks, everything is exposed. Use different passwords per client, project, or sensitivity level.
• Leaving the original unprotected copy in the same shared folder: Check that you have not left an earlier unprotected version sitting beside the protected one where everyone can open it.

Conclusion

Password-protecting an Excel file properly means using Encrypt with Password from File > Info, choosing a long and unique password, saving the file, and testing that the prompt appears on reopening. Use a modify password for templates you want read but not overwritten, and sheet protection only as a guard against accidents, never as security. Record the password safely, share it separately from the file, and your spreadsheets will stay readable only by the people you intend.

Frequently Asked Questions

Can Microsoft or anyone else recover my Excel password if I forget it?

No. Microsoft does not store your file password and offers no recovery service for it. Third-party tools can only try to guess the password, which is impractical for a long, strong one. This is why storing the password in a password manager is essential.

Is Excel password protection secure enough for sensitive data?

Modern Excel versions use strong AES-256-based encryption for the password-to-open feature, which is considered secure when paired with a long, unique password. Weak or short passwords can still be guessed, so password quality decides the real level of protection.

Can someone open my protected file in Google Sheets or LibreOffice?

Both can open standard encrypted Excel files after you enter the correct password, because they support the same encryption standard. Sheet protection settings, however, may behave slightly differently in other programs.

What is the difference between Protect Workbook and Encrypt with Password?

Protect Workbook restricts changes to the workbook structure, such as adding, deleting, or renaming sheets. Encrypt with Password scrambles the entire file contents so nobody can even view the data without the password. Only encryption provides confidentiality.

Why does Excel ask for the password twice when I set it?

The second prompt is a confirmation to make sure a typing mistake does not lock you out of your own file. If the two entries do not match, Excel asks you to try again rather than saving a password you did not intend.