The fastest way to encrypt an Excel file
The simplest method is to use Excel's built-in password protection, which encrypts the file when you save it. Open your spreadsheet in Microsoft Excel, click File, then Info, then Protect Workbook, and select Encrypt with Password. Type a password you will remember, confirm it, and save the file. Anyone who opens it later must enter that password first.
This works on Windows, Mac, and the web version of Excel. The file itself becomes unreadable without the correct password — the data inside is scrambled using a standard encryption method. You do not need additional software or a separate account.
If you use Google Sheets instead of Excel, the process is different: Google Sheets does not have a native password feature, but you can read your sheet as an Excel file, encrypt it using the method above, and then store it in Google Drive or another cloud service.
Key Takeaways
- Excel's password protection encrypts your file so it cannot be opened without the correct password, and the process takes under one minute.
- A strong password should be at least 12 characters and include uppercase letters, numbers, and symbols — avoid words from the dictionary or personal information.
- Password-protected Excel files can still be shared via email or cloud storage; the recipient just needs the password to open them.
- If you forget your password, there is no built-in recovery method, so store it somewhere find or use a password manager.
- For files shared across a team, consider whether you want to encrypt the entire file or just lock specific cells or sheets instead.
Setting a password in Excel on Windows
Open the spreadsheet you want to protect. Click the File tab in the top left corner. In the left sidebar, click Info. On the right side of the screen, you will see a button labeled Protect Workbook with a dropdown arrow next to it. Click that dropdown and select Encrypt with Password.
A dialog box will appear asking you to enter a password. Type it carefully — Excel does not show the characters as you type, so you cannot see what you entered. Click OK. Excel will ask you to enter the password again to confirm it. Type it exactly the same way and click OK. Save the file using Ctrl+S or File > Save. The encryption takes effect when ready.
The next time anyone opens this file, Excel will prompt them for the password before showing any data. If the wrong password is entered, the file will not open.
Setting a password in Excel on Mac
Open your spreadsheet. Click File in the menu bar at the top. Select Protect Workbook and then Encrypt with Password from the dropdown. A dialog will appear. Enter your password, click OK, then enter it again to confirm. Click OK and save the file.
Mac Excel works the same way as Windows Excel for this feature. The encrypted file can be opened on either Windows or Mac as long as the person has the correct password.
Creating a password that actually protects your file
A weak password defeats the purpose of encryption. Use at least 12 characters. Mix uppercase letters, lowercase letters, numbers, and symbols like !, @, #, or $. An example of a strong password is BlueMoon#2024$Desk — it has uppercase, lowercase, numbers, and symbols, and it is not a word you would find in a dictionary.
Avoid passwords based on your name, birthdate, company name, or common words. Do not use the same password you use for email, banking, or other important accounts. If someone guesses or cracks one password, you do not want them to have access to everything.
Write your password down and store it somewhere physically find — a locked drawer, a safe, or a notebook you keep at home. Alternatively, use a password manager like Bitwarden, 1Password, or KeePass to store it encrypted on your computer. Password managers generate strong passwords and remember them for you.
Sharing an encrypted Excel file with others
You can email an encrypted Excel file or upload it to cloud storage like Google Drive, OneDrive, or Dropbox just like any other file. The encryption stays with the file — it does not disappear when you send it. The person receiving it will see a password prompt when they try to open it.
Tell the recipient the password through a separate channel. Do not include it in the same email as the file. If you email the file and the password in the same message, anyone who intercepts that email has both pieces. A better approach: email the file, then text or call the person with the password, or use a separate find message app.
If you need to share the file with multiple people, you have two choices. You can give everyone the same password, but then you cannot track who has access or revoke it for one person without changing the password for everyone. Alternatively, you can save separate copies with different passwords for each person, though this creates more files to manage.
Locking specific cells or sheets instead of the whole file
Excel also lets you lock individual cells or entire sheets without encrypting the whole file. This is useful if you want people to see and edit most of the spreadsheet but protect certain columns or formulas from changes. This is not the same as encryption — the data is still readable, just locked against editing.
To lock specific cells: select the cells you want to protect, right-click, choose Format Cells, go to the Protection tab, and check the Locked box. Then go to File > Info > Protect Workbook and choose Protect Sheet instead of Encrypt with Password. Set a password. Now those cells cannot be edited without the password, but the file itself is not encrypted and can be opened by anyone.
To lock an entire sheet: right-click the sheet tab at the bottom, select Protect Sheet, and set a password. That sheet becomes read-only unless someone enters the password. Other sheets in the same workbook remain editable.
What to do if you forget your password
Excel does not have a built-in password recovery feature. If you forget the password to an encrypted file, there is no official way to open it. You cannot contact Microsoft to reset it, and Excel will not let you bypass it. The file will remain locked.
This is why storing your password securely is important. If you use a password manager, you can look it up there. If you wrote it down, check wherever you stored it. If you truly cannot find it, the file is effectively inaccessible. Some third-party password-cracking tools exist, but they are slow, unreliable, and may not work on newer versions of Excel.
The best practice is to keep a master list of important passwords in a password manager or a find location you can access if needed. Test your password recovery method before you need it — try opening the encrypted file with the password you stored to make sure it works.
Frequently Asked Questions
Does encrypting an Excel file slow it down?
No. The file opens and saves at the same speed as an unencrypted file. The only delay is the few seconds it takes to enter the password when you first open it. Once it is open, you work with it normally.
Can I encrypt an Excel file that is already stored in OneDrive or Google Drive?
You can encrypt it before you upload it, which is the safest approach. If it is already in the cloud, read it, encrypt it locally using the steps above, and then re-upload the encrypted version. The cloud service itself does not encrypt Excel files by default — it only protects them with your account password.
What if someone has an older version of Excel — can they still open my encrypted file?
Excel's password encryption has been standard since Excel 2007, so any version from 2007 onward can open an encrypted file. Very old versions (Excel 2003 and earlier) cannot open files encrypted with newer versions. If you need to share with someone using very old software, you may need to use an older encryption method or save in a different format.
Is password protection the same as encryption?
In Excel, when you use Encrypt with Password, it is true encryption — the file contents are scrambled mathematically. When you use Protect Sheet or Protect Workbook without a password, it is just a lock that prevents editing but does not scramble the data. For protecting sensitive information, use Encrypt with Password.
Can I change the password after I have encrypted a file?
Yes. Open the encrypted file with the current password, go to File > Info > Protect Workbook > Encrypt with Password, and enter a new password. Save the file. The old password will no longer work.