Password Protect an Excel Document to Open

How-to basics · Updated November 20, 2026

Yes. In Excel for Microsoft 365 on Windows, open the workbook and choose File > Info > Protect Workbook > Encrypt with Password, enter a password, confirm it, and save the file. Excel will then ask for that password before someone can open the workbook; this is different from protecting a worksheet or workbook structure.

How to require a password to open an Excel file

Use the desktop Excel app and make sure you are working with the workbook you intend to protect. The encryption setting applies to that file, not to every workbook in Excel or to a folder containing it. Before changing protection, consider saving a separate backup in a secure location in case you later forget the password or need an unprotected working copy.

  1. Open the workbook in Excel for Microsoft 365 on Windows.
  2. Select File, then Info.
  3. Select Protect Workbook, then Encrypt with Password. If Excel displays a password box directly, you are in the right setting.
  4. Type the password and select OK. Enter it again when prompted to confirm it.
  5. Save the workbook. Close it and reopen it to check that Excel asks for the password.

Passwords are case-sensitive, so capitalization matters. Excel does not show a password hint or recover it for you later. If you use a password manager, save the entry with a clear label identifying the workbook and keep access available to the people who genuinely need the file. Do not send the password in the same message as the workbook attachment; use a separate, reasonably secure channel.

In Excel for Microsoft 365 on Mac, password options are available through File > Passwords in supported builds; the exact controls can differ by version. Excel for the web does not offer the desktop command for adding or removing this file-level encryption. Use the desktop app to set it, and check that recipients can open the encrypted file in their version of Excel before relying on a browser workflow.

What password encryption does

A password to open is intended to encrypt the workbook’s contents. Without the correct password, a person opening the file in a compatible Excel app should not be able to read its worksheets simply by opening the file. That makes it meaningfully different from a warning prompt or a setting that only discourages editing. Modern Excel workbook encryption is designed to protect the file, but the practical protection still depends on choosing a strong, private password and controlling copies of the file.

Encryption protects the workbook file itself, not every place its information might appear. Someone who already knows the password can open the workbook, copy data, take screenshots, or save another copy. If an unprotected copy is emailed, downloaded, or stored elsewhere, the original file’s password does not protect that copy. Password protection also does not replace device security, secure backups, or appropriate access controls on a shared drive.

Do not confuse the password prompt with a label, banner, or message that merely says a workbook is confidential. Those measures may communicate handling expectations but do not necessarily encrypt the file. If confidentiality matters, reopen the saved workbook and verify that the password prompt appears rather than assuming that selecting a protection option completed the job.

Choose a strong password and keep it recoverable

Choose a password that is difficult to guess and not reused for email, cloud storage, or other accounts. A longer passphrase made from unrelated words can be easier to enter accurately than a short string of complicated characters, provided it is not a familiar quotation or predictable phrase. Avoid names, workbook subjects, company names, dates, and simple variations of passwords that other people may already know.

  • Use a password manager to generate and store a unique password.
  • Share it only with people who need to open the workbook, and communicate it separately from the file.
  • Keep an approved recovery copy or documented handoff process if the workbook must remain available when its owner is away.
  • Check that intended recipients can enter the password and open the file before distributing it widely.

There is an important trade-off: a strict password can reduce unwanted access, but a lost password can also block legitimate users. Microsoft does not provide a way to retrieve a forgotten password for an encrypted workbook. A password manager, an authorized backup, and a clear ownership process are safer than relying on someone to remember the password months later.

Password to open versus sheet and workbook protection

Excel has several features described as protection, and their names can make them sound more alike than they are. A password to open encrypts the file. Protect Sheet limits changes to cells or objects on a worksheet, while Protect Workbook can restrict structural changes such as adding, deleting, moving, hiding, or renaming sheets. Those worksheet and structure controls are useful for preventing accidental edits, but they are not substitutes for encrypting a file that must remain unreadable to someone without permission.

For example, a budget workbook might have formulas locked with Protect Sheet so colleagues can enter figures only in designated cells. If the same workbook contains confidential salary data and should not be readable by people who receive the file, use a password to open as well. The two protections address different needs and can be used together. A sheet-protection password should not be presented as though it prevents a recipient from viewing the sheet’s information.

Likewise, marking a workbook read-only or recommending that a recipient open it as read-only is mainly about reducing accidental edits. It does not stop someone from reading the contents, and it may not prevent them from saving a copy under another name. Pick the feature based on the goal: confidentiality, control over edits, or both.

Changing or removing the password

To change an existing open password, first open the workbook with its current password. Return to File > Info > Protect Workbook > Encrypt with Password, replace the existing password, confirm the new one, and save the workbook. The old password is needed to get into the protected file before changing its setting.

To remove the password, open the workbook, go to the same Encrypt with Password box, delete the password so the box is blank, select OK, and save. Close and reopen the file to confirm it no longer asks for a password. Removing encryption means anyone who can access that file may be able to open it, so check where it is stored and who can reach it before sharing the unprotected version.

If you make a new copy with Save As, do not assume that every copy has the protection state you intended. Test the exact file you plan to send, especially if you have exported it to another format or copied it to a different location.

Common problems and safe troubleshooting

  • The file opens without asking for a password. You may have protected a sheet or workbook structure instead of choosing Encrypt with Password, or you may be opening a different copy. Check the exact file and repeat the open-password test after saving.
  • The password is rejected. Check capitalization, keyboard layout, language settings, and accidental spaces at the beginning or end. Confirm that the recipient has the current password rather than an earlier one.
  • You forgot the password. Look in the password manager, approved documentation, or a secure backup process. Microsoft cannot retrieve the password for an encrypted workbook. Avoid uploading confidential files to unknown password-removal websites or tools; doing so can expose the contents.
  • A recipient cannot open the file in a browser or another spreadsheet app. Ask them to try a supported desktop version of Excel and confirm the password. Compatibility and browser capabilities can vary, so test the intended workflow before sending a file to a large group.
  • The file appears damaged after a failed attempt. Do not repeatedly overwrite the only copy. Keep the original unchanged, work from a backup, and confirm that the file was fully downloaded or transferred before troubleshooting further.

There is no safe shortcut around the basic rule: if the password is lost and no authorized unencrypted backup exists, access may be impossible. Third-party recovery tools may make claims about finding or removing passwords, but they are not a dependable substitute for a recovery plan and may create privacy or malware risks. For sensitive business files, follow the organization’s approved IT and records procedures rather than sending the workbook to an unknown service.

Sharing, cloud storage, and file formats

A password to open travels with the encrypted workbook, so each authorized recipient needs the password to open that copy. This is separate from permissions in OneDrive, SharePoint, or a file server. Cloud permissions can control who can access or share a stored file; workbook encryption protects the file contents if a copy is obtained. Using both can provide distinct layers of control, but neither prevents an authorized recipient from copying information after opening it.

Before distributing a protected workbook, consider whether recipients need to edit it, whether they use desktop Excel, and how the password will be delivered. Some review, preview, indexing, or coauthoring experiences may not behave like opening an ordinary unencrypted workbook. Test the actual combination of file location, Excel version, and collaboration method. If smooth browser-based editing is essential, an encrypted workbook may not fit that workflow; consider using access-controlled cloud storage instead, subject to your organization’s requirements.

For a regular Excel workbook, keep the file in an Excel format such as .xlsx or .xlsm as appropriate, and test any conversion before sending. Saving to formats such as CSV does not preserve a workbook’s sheets, formulas, formatting, and protection features as a complete Excel workbook. Do not treat a changed file extension as encryption; it neither adds a valid password nor safely converts the file.

When another approach may be better

File encryption is suitable when the requirement is that a password be entered before the workbook opens. If the main concern is who can retrieve the file, use carefully managed sharing permissions on a trusted storage service. If the workbook is intended for collaborative editing, assign access to named accounts and review sharing links rather than distributing a single password-protected attachment that can be forwarded.

If the goal is to stop accidental changes, Protect Sheet or workbook-structure protection may be more convenient. If the goal is to prevent disclosure after a legitimate user has opened the file, a password alone cannot guarantee that outcome. Use organizational information-protection tools or a controlled data system where available, and follow your employer’s policies for confidential information. The right choice depends on whether you need to restrict opening, restrict editing, manage sharing, or combine those protections.

Frequently Asked Questions

Can I password-protect an Excel file so it cannot be opened?
Yes. Use File > Info > Protect Workbook > Encrypt with Password in Excel for Microsoft 365 on Windows, then save. This is the open-password option, not Protect Sheet.

Can I recover a forgotten Excel opening password?
Microsoft cannot retrieve a forgotten password for an encrypted workbook. Check a password manager or an authorized backup. Keep an accessible recovery copy when your work or organization requires one.

Does protecting a worksheet hide its contents?
No. Worksheet protection is intended to limit editing, not to encrypt the workbook against viewing. Use Encrypt with Password when the file must require a password to open.

Can I open a password-protected workbook in Excel for the web?
The web app does not provide the desktop command for setting or removing file encryption, and encrypted workbook workflows may require desktop Excel. Test with the recipient’s version before depending on browser access.

How do I remove an Excel password?
Open the file with its current password, return to Encrypt with Password, clear the password box, select OK, and save. Reopen the saved file to verify the prompt is gone before sharing it.

Does a password stop someone from copying data after opening the workbook?
No. It controls access to the encrypted file, but an authorized person who opens it can still copy or capture its contents. Manage recipient access and copies as well as the password.

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.