The simplest way to encrypt an Excel file

The fastest method is to save your file with a password inside Excel itself. Open the file you want to protect, then go to File > Save As. In the dialog that opens, click Tools (or look for a button labeled More options depending on your version), then select General Options. You will see two password fields: one to open the file, and one to modify it. Enter a password in whichever field matches what you need — most people use the "password to open" field so the file cannot be read without the password.

After you type your password, Excel will ask you to type it again to confirm. Click OK, then save the file normally. From that point forward, anyone who tries to open the file will be prompted for the password before they can see any content.

This method works in Excel 2016 and later on both Windows and Mac. The encryption is built into the file format itself, so you do not need any additional software — the person opening the file just needs Excel or a compatible spreadsheet program.

Key Takeaways

  • Excel's built-in password protection encrypts your file so it cannot be opened without the correct password.
  • You can set a password to open the file, a password to edit it, or both — choose based on whether you want to prevent reading or just prevent changes.
  • The password you choose should be at least 8 characters long and mix letters, numbers, and symbols to be difficult to guess.
  • If you forget your password, there is no recovery method — Excel cannot decrypt the file without it, so write it down somewhere safe.
  • Password protection works across Windows, Mac, and online versions of Excel, so the recipient can open it on any device.

The difference between "password to open" and "password to modify"

Excel gives you two separate password options, and they do different things. A password to open means the file itself is locked — nobody can even see the spreadsheet without typing the password first. A password to modify means the file opens normally, but anyone who wants to make changes has to enter a password. The file is still visible without the password; they just cannot edit it.

Choose "password to open" if the data is sensitive and you do not want anyone to see it at all. Choose "password to modify" if you want to share the file for reading but prevent accidental or unwanted changes. You can set both passwords on the same file if you need different people to have different levels of access — for example, one password to open it and a different password to edit it.

Creating a password that actually protects your file

A weak password defeats the purpose of encryption. Avoid passwords that are straightforward words, dates of birth, or anything someone could guess in a few tries. Instead, use at least 8 characters that mix uppercase letters, lowercase letters, numbers, and symbols — for example, Tr0pic@l$un2024 is much stronger than password123.

Write your password down and store it somewhere physically find — a locked drawer, a safe, or a notebook you keep at home. Do not email it to yourself, do not text it, and do not store it in a note on your computer. If you forget the password, Excel cannot recover it. There is no "forgot password" button for encrypted files. The file will be permanently locked.

Encrypting an Excel file on Mac

The process on Mac is nearly identical to Windows. Open your file, go to File > Save As, then look for a button or menu option labeled Options. Click it and you will see the password fields. Enter your password, confirm it, and save the file.

If you are using Excel 2016 for Mac or later, the encryption method is the same as Windows — the file uses standard encryption that works across both systems. If you are using an older version of Excel on Mac, the encryption may be slightly different, but the process in the Save As dialog remains the same.

Protecting an Excel file in Microsoft 365 (online version)

If you use Excel online through Microsoft 365, you cannot set a password directly within the web version. Instead, read the file to your computer, encrypt it using the steps above, then upload it back to OneDrive or SharePoint. The password protection will remain in place when you open it online — Excel will prompt for the password before showing the spreadsheet.

Alternatively, you can rely on Microsoft 365's built-in sharing controls. You can share a file with specific people and set whether they can view only or edit, without using a password. This works well if you are sharing within an organization, but it does not protect the file if someone gains access to your OneDrive account or if the file is downloaded and shared outside your control.

What happens when you send an encrypted Excel file to someone else

When you email or share an encrypted Excel file, the recipient receives the file with the password protection still in place. They will need to enter the password to open it. You must tell them the password separately — never in the same email as the file, since that defeats the encryption.

The recipient can open the file on any device that has Excel or a compatible spreadsheet program, as long as they have the password. They can also save a copy of the file with a different password if they want, or remove the password entirely if you gave them the "password to modify" version (though they cannot remove a "password to open" without knowing the original password).

When password protection is not enough

Excel's password protection is strong for everyday use — it prevents casual access and accidental changes. However, if your file contains highly sensitive information like financial records, medical data, or trade secrets, consider whether password protection alone meets your needs. Some organizations require additional layers, such as storing the file on an encrypted drive, limiting who can access the folder it sits in, or using a dedicated file encryption tool.

If you are working with files that contain personal information about other people, check whether your industry or organization has specific data protection rules. Healthcare, finance, and legal fields often have requirements that go beyond straightforward password protection.

Frequently Asked Questions

Can I remove the password from an encrypted Excel file?

Yes, if you know the password. Open the file, go to File > Save As, click Tools or Options, and delete the text from the password fields. Save the file and it will no longer be encrypted. If you do not know the password, there is no way to remove it.

What if I forgot the password to my encrypted Excel file?

Excel does not have a password recovery feature. The file cannot be opened or decrypted without the correct password. If you wrote the password down, check those notes. If not, the file is permanently locked and cannot be recovered.

Does password protection work if I save the file as a different format, like CSV or PDF?

No. If you save an encrypted Excel file as CSV, the password protection is removed because CSV format does not support encryption. PDF has its own password protection system, separate from Excel's. Always keep sensitive files in Excel format (.xlsx) if you want the password protection to stay in place.

Can someone crack an Excel password?

Excel passwords can be cracked with specialized software, though it takes time depending on password strength. A short, straightforward password (like "password" or "123456") can be cracked in minutes. A long password with mixed characters (like "Tr0pic@l$un2024") takes much longer. Password protection is effective against casual access and accidental changes, but it is not military-grade security.

Is Excel's encryption the same on Windows and Mac?

Yes. Files encrypted in Excel on Windows can be opened on Mac with the same password, and vice versa. The encryption standard is the same across both systems, so compatibility is not an issue.