Encrypt an Excel File: Steps, Limits, and Safer Sharing

How-to basics · Updated November 22, 2026

To encrypt an Excel file in Microsoft Excel for Microsoft 365 on Windows, open the workbook and choose File > Info > Protect Workbook > Encrypt with Password. Enter and confirm a strong password, then save the file. Encryption requires that password to open the workbook; it is different from protecting a sheet or preventing edits.

What encrypting an Excel file means

Encryption turns workbook contents into data that cannot be read normally without the correct password. When you use Encrypt with Password, the password is required to open the file, rather than merely to change a particular cell or sheet. This makes it useful when a workbook contains information that should not be visible to someone who obtains a copy of the file.

That distinction matters because many Excel features called protection do not encrypt the contents. A protected worksheet can limit actions such as editing locked cells, while workbook-structure protection can prevent changes to sheet tabs. Those controls are useful for avoiding accidental changes, but they are not substitutes for a password required to open an encrypted file.

Encryption protects the saved workbook itself. It does not automatically protect a printed copy, a screenshot, an unencrypted copy saved elsewhere, or information someone has already read while the workbook is open. Consider the whole process of storing and sharing the file, not only the setting applied inside Excel.

How to encrypt the workbook on Windows

Use the desktop version of Excel for Microsoft 365 on Windows. The steps are:

  1. Open the workbook you want to protect. If it is important, first save a separate backup in a secure location.
  2. Select File, then Info.
  3. Select Protect Workbook, then Encrypt with Password.
  4. Enter a password in the password box and select OK.
  5. Enter the same password again when prompted, then select OK.
  6. Save the workbook. Close it and reopen it to confirm that Excel asks for the password.

The password is case-sensitive, so uppercase and lowercase letters must match. Excel does not show a password-recovery prompt that can restore access if you forget it. Check that you can reopen the saved file before deleting any unencrypted original, and store the password separately from the workbook.

On Excel for Mac, use the desktop app and look under File > Passwords to set a password to open the workbook. The wording and available options can vary with the Mac version. Excel for the web does not provide the same desktop encryption workflow; open the file in the desktop app to set or change its opening password.

Choose and store a strong password

A password that is easy to guess can undermine the practical value of encryption. Avoid a person’s name, a company name, a short word, or a predictable pattern such as a date. A longer, unique passphrase is generally easier to remember and harder to guess than a short password built from familiar details.

Use a password that you have not reused for email, cloud storage, or another account. Reuse creates a chain of risk: if one service or file is exposed, the same password may help someone access other material. A reputable password manager can generate and store a unique password. For a shared workbook, decide how recipients will receive it before sending the file.

  • Keep the password out of the workbook and out of the same message as the attachment.
  • Send it through a separate, trusted channel, such as a call or a secure messaging system.
  • Share it only with people who need access, and remove access to the file when it is no longer needed.
  • Keep a protected backup of important workbooks and the password-recovery information needed by the responsible team.

For example, if you email an encrypted workbook to a colleague, sending its password in the same email account may offer little separation if that account is compromised. A separate channel reduces that particular risk, although it cannot prevent an authorized recipient from copying or redistributing information after opening the file.

What encryption protects—and what it does not

An opening password is useful when a workbook is stored on a laptop, removable drive, or shared folder where someone might access the file without permission. It can also add a layer of protection when sending a workbook to a specific recipient. Modern Excel workbook formats support file encryption when this feature is applied in the desktop app.

Encryption does not control every later use of the data. Once a person with the password opens the workbook, they may be able to read, copy, photograph, or otherwise capture its contents. The password does not automatically expire, identify who opened the file, or revoke an already-downloaded copy. It is a way to restrict opening, not a complete access-management or auditing system.

It also does not make an unsafe computer safe. Malware, a compromised account, a weak password, or an exposed backup may defeat other parts of the protection plan. Keep software updated, use device security and account protections, and limit where sensitive copies are stored. If the file contains highly sensitive personal, health, financial, or business information, follow the applicable organizational rules rather than relying on an Excel setting alone.

Encryption compared with sheet and workbook protection

Excel offers several protection controls, and choosing the right one depends on the problem you want to solve:

  • Encrypt with Password: requires a password to open the workbook. Use it when the contents themselves should not be accessible to someone without the password.
  • Protect Sheet: restricts actions on a worksheet, such as editing locked cells. It is primarily a way to control changes, not to hide the workbook contents from a determined person.
  • Protect Workbook: can protect workbook structure, such as adding, moving, or deleting sheets. It does not serve the same purpose as an opening password.
  • OneDrive or SharePoint access controls: manage who can access a cloud-stored file through their account and the permissions granted. These controls can be more practical for ongoing collaboration, but they are not the same as encrypting a downloaded workbook with a password.

A common misconception is that a hidden sheet or protected worksheet makes confidential data secret. Hidden sheets can be revealed, and worksheet protection is designed mainly to discourage or prevent ordinary editing. If a recipient must not see particular data, do not include that data in a workbook you share with them. If recipients should see the file but not alter it, use appropriate sharing permissions and consider a read-only copy as well as the protections your workflow requires.

Sharing encrypted files and compatibility

Recipients need the password and an application that can open the encrypted workbook. Current desktop versions of Excel support password-protected workbooks, but behavior can differ in other spreadsheet apps, older software, preview tools, and automated file-processing systems. A file may appear unreadable to a preview service until it is opened with the password, and some third-party tools may not handle the encryption feature as expected.

Before distributing a workbook broadly, test a copy with the software recipients are expected to use. This is especially important if the workbook contains macros, external data connections, specialized formatting, or features that already depend on a particular Excel version. Password encryption does not remove those compatibility considerations.

When sharing through OneDrive or SharePoint, think about whether an opening password or account-based permissions best fit the situation. Cloud permissions can make it easier to grant or withdraw access for named users, while an emailed password-protected attachment can be difficult to recall after it has been downloaded. Neither approach stops an authorized reader from taking a separate copy. For sensitive work, follow your organization’s approved sharing and retention practices.

How to remove or change the password

To remove an opening password in Excel for Microsoft 365 on Windows, open the workbook using its current password, then go to File > Info > Protect Workbook > Encrypt with Password. Clear the password field, select OK, and save the workbook. Reopen the saved file to check that it no longer prompts for a password. The Mac desktop app has its password controls under File > Passwords; remove the opening password there and save the workbook.

To change a password, use the same control, replace the existing password with the new one, confirm it, and save. Tell authorized users about the change through a suitable channel. If you want to keep the workbook protected, do not leave the password field blank. Make sure any copies or backups you intend to keep have the protection level you expect; changing one file does not update separate copies already sent to others.

Common problems and recovery limits

If Excel does not ask for a password after you set one, verify that you chose Encrypt with Password rather than Protect Sheet or Protect Workbook. Save the file, close it, and reopen it to test. Also check that you are opening the saved copy you changed, not an earlier version with the same or a similar filename.

If a recipient cannot open the file, confirm that they have the correct password, including its capitalization, and that they are using an application that supports the encrypted format. Avoid sending the password in a reply attached to the same email thread as the file. If a workbook is stored in a cloud location, check that the recipient has permission to download or open the file in addition to giving them the password.

If the password is lost, Microsoft cannot retrieve it for you. There is no reliable built-in recovery route for an encrypted workbook without the password. Check an approved password manager, secure organizational records, or a backup that you are authorized to use. Be cautious of websites or programs claiming guaranteed recovery: uploading a confidential workbook to an untrusted service can expose its contents, and recovery claims may be misleading.

Frequently Asked Questions

Can I encrypt an Excel file without a password?
No. The Encrypt with Password feature uses a password to control opening the workbook. If you need access control without asking recipients to manage a shared file password, consider controlled sharing through OneDrive or SharePoint where appropriate.

Can I encrypt an Excel file in Excel for the web?
The web app does not offer the same password-encryption setting as desktop Excel. Open the workbook in the desktop app, set the opening password there, and save it. Check the saved file in the desktop app before sharing.

Does Protect Sheet encrypt my spreadsheet?
No. Protect Sheet limits certain editing actions; it is not equivalent to an opening password. Use Encrypt with Password when the workbook contents should require a password to open.

Can Microsoft recover a forgotten Excel password?
No. Microsoft does not provide a way to retrieve a forgotten password for an encrypted workbook. Keep a secure record of the password and maintain authorized backups before you need them.

Can I remove an Excel password if I know it?
Yes. Open the workbook with the current password, go to File > Info > Protect Workbook > Encrypt with Password on Windows, clear the password field, and save. On Mac, use File > Passwords.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.