The fastest way: password-protect your file

The simplest method is to add a password that Excel requires before anyone can open the file. This works in Excel 2016 and later on Windows, and Excel 2016 and later on Mac. Open your file, go to File > Info > Protect Workbook > Encrypt with Password. Type a password you will remember, then type it again to confirm. Save the file. From now on, anyone who tries to open it will see a password prompt.

This method encrypts the entire file using AES-128 encryption, which means the data inside is scrambled in a way that requires the correct password to unscramble. If you lose the password, Microsoft cannot recover it for you — the file becomes unreadable. Write your password somewhere safe, separate from the file itself.

Password protection works for .xlsx files (the standard Excel format) and older .xls files. It does not work if you save the file as .csv or .txt, because those formats do not support encryption. If you need to share the file, you will have to send the password separately — never in the same email or message as the file.

Key Takeaways

  • Password protection in Excel uses AES-128 encryption and requires only a few clicks: File > Info > Protect Workbook > Encrypt with Password.
  • You must save the file after setting the password, and anyone opening it will need that exact password — Microsoft cannot recover a lost password.
  • Password protection only works in .xlsx and .xls formats; saving as .csv or .txt removes the encryption.
  • If you share the file, send the password through a separate channel (phone call, different email, in person) rather than alongside the file itself.
  • For files stored in OneDrive or SharePoint, folder-level permissions add a second layer of control beyond file-level encryption.

When password protection is enough

File-level password protection is sufficient for most situations: a spreadsheet with financial data you keep on your computer, a budget file you email to a spouse, a client list you store on an external drive. The password prevents casual access — someone who borrows your laptop or finds a backup file cannot open it without the password.

It is not sufficient if you are protecting against someone with technical skill who has physical access to your computer for an extended period. A determined attacker with the right tools can attempt to crack the password, especially if it is short or uses common words. For most people, most of the time, a strong password (12+ characters, mix of uppercase, lowercase, numbers, and symbols) is a practical barrier.

Protecting specific sheets or ranges instead of the whole file

You can also lock individual sheets or ranges of cells so that only people with the password can edit them, while still allowing others to view the file. Go to Review > Protect Sheet (or Protect Workbook for the whole workbook structure). Choose what you want to allow — typically you would allow viewing and printing but block editing. Set a password and save.

This approach is useful when you want to share a file with colleagues who should see the data but not change it, or when you want to lock formulas in place while allowing others to enter data in specific cells. The person opening the file does not need a password to see it; they only need a password if they try to edit a protected area.

Be aware that sheet protection is weaker than file-level encryption. Someone with moderate technical skill can remove sheet protection without knowing the password. Use it to prevent accidental changes, not to protect sensitive information from someone determined to access it.

Storing encrypted files in the cloud safely

If you store your password-protected Excel file in OneDrive, Google Drive, or Dropbox, the encryption you set in Excel protects the file contents. The cloud service itself cannot read the data inside — only someone with the password can. However, the file name, file size, and access logs are visible to the service provider.

Add an extra layer by controlling who can access the folder or file through the cloud service's sharing settings. In OneDrive, right-click the file, select Share, and choose Specific people rather than Anyone with the link. In Google Drive, click the Share button and set permissions to specific email addresses. This way, even if someone guesses your password, they cannot access the file unless they also have permission from the cloud service.

If you are storing financial records, health information, or other highly sensitive data, consider keeping the file on an external drive or your computer rather than in the cloud. Cloud storage is convenient but adds another organization (the cloud provider) that has access to your file's location and metadata.

Creating a strong password you can actually remember

A password like "Excel2024" or "Budget123" is quick to type but straightforward to crack. A password like "BlueSock$Lamp7Desk" is harder to crack because it is longer and mixes unrelated words. You do not need symbols or numbers if the password is long enough — length matters more than complexity for resisting automated attacks.

One method: think of a sentence you know well, take the first letter of each word, and add a number or symbol. "My daughter was born on March 15th" becomes "MdwbomM15" — 9 characters, mixed case, includes a number. Or use a passphrase: "correct-horse-battery-staple" (the longer, the better). Write it down and store it somewhere separate from your computer — a notebook in a drawer, a safe, or a trusted person you can call if you forget.

Do not use passwords based on your name, birth date, address, or other information someone could find online or guess. Do not reuse the same password across multiple files or accounts.

What happens if you forget your password

If you forget the password to an encrypted Excel file, the file is unrecoverable. Excel does not have a "forgot password" recovery option, and Microsoft support cannot unlock it. This is by design — the encryption is strong enough that even Microsoft cannot break it without the password.

If you have a backup copy of the file from before you added the password, you can use that. Otherwise, the file is lost. This is why writing down your password and storing it safely is important. If you manage multiple encrypted files, consider keeping a password list in a locked drawer or a password manager like Bitwarden or 1Password.

Frequently Asked Questions

Can I password-protect an Excel file on a Mac?

Yes. Open the file, go to Tools > Protect Workbook > Encrypt with Password. The process is the same as on Windows, and the encrypted file can be opened on either Mac or Windows as long as the password is correct.

Does password protection slow down Excel?

No. Encryption and decryption happen when you open and save the file, not while you are working in it. You will not notice any difference in performance while the file is open.

Can I remove the password from an encrypted file?

Yes, if you know the password. Go to File > Info > Protect Workbook > Encrypt with Password, leave the password field blank, and save. The file will no longer be encrypted.

What if I share an encrypted file and the person cannot open it?

Make sure you gave them the correct password and that they are typing it exactly as you wrote it (passwords are case-sensitive). If they are using an older version of Excel or a non-Microsoft spreadsheet program, they may not be able to open AES-encrypted files. Ask them to update their software or use Microsoft Excel Online, which supports encrypted files.

Is password protection the same as backing up my file?

No. Encryption protects your file from being read by someone without the password, but it does not protect against data loss if your computer fails or the file is deleted. Keep a backup copy in a separate location — an external drive, a cloud service, or both — in addition to encrypting the file.