Excel 365 Password Protection: How to Do It Safely

How-to basics · Updated November 18, 2026

To password-protect an entire Excel 365 workbook on Windows, open it and choose File > Info > Protect Workbook > Encrypt with Password, enter a password, confirm it, and save the file. For protection against accidental edits rather than access to the file, use Review > Protect Sheet or Review > Protect Workbook instead; these controls do different jobs.

Choose the kind of protection you need

“Password-protect an Excel file” can mean several things. The distinction matters: a password that blocks people from opening a file is not the same as one that stops edits to a worksheet or changes to the workbook’s sheet tabs.

  • Encrypt the file with a password: Someone needs the password to open the workbook. This is the appropriate built-in option when you want to restrict access to the contents.
  • Protect a worksheet: You can limit which cells people may change and which actions they may take on that sheet. This is mainly a way to prevent accidental edits, not to keep the data secret.
  • Protect workbook structure: You can restrict changes to the workbook’s sheet arrangement, such as adding, deleting, renaming, hiding, or moving sheets.

These protections can be combined. For example, a budget file might be encrypted so only intended recipients can open it, have its formula cells protected against editing, and have its sheet structure protected against accidental changes. The protections should match the risk: sheet protection alone does not stop someone from opening the file and viewing its contents.

Encrypt the whole workbook on Windows

In the Microsoft 365 desktop app for Windows, use the following steps to require a password when the workbook is opened:

  1. Open the workbook and select File.
  2. Select Info, then Protect Workbook.
  3. Choose Encrypt with Password.
  4. Type a strong password, select OK, and type it again to confirm.
  5. Save the workbook. Close it and reopen it to check that Excel asks for the password.

The password is case-sensitive. You must enter it to open the encrypted workbook, so keep it somewhere dependable, such as a reputable password manager. If you leave the password field blank when setting the option, you are not adding meaningful access protection. Make sure the file is saved after applying encryption; if you send or upload it, verify that you are sharing the newly saved, protected copy rather than an earlier unprotected version.

To remove the open password in desktop Excel for Windows, open the workbook with its current password, go back to File > Info > Protect Workbook > Encrypt with Password, clear the password field, select OK, and save. Removing encryption makes the saved file accessible without that password, so check that this is appropriate before sharing it.

Protect a worksheet from unwanted edits

Worksheet protection is useful when other people need to work in a workbook but should not accidentally alter formulas, headings, or layout. It does not encrypt the sheet or hide its information. A recipient can generally open a sheet-protected workbook and read the cells.

To turn it on, select the worksheet and choose Review > Protect Sheet. In the dialog, choose the actions users should be allowed to perform, such as selecting cells or formatting cells. You can enter a password, confirm it, and select OK. If you do not set a password, the sheet can be unprotected without one; a password makes the protection more useful for avoiding casual changes, but it still should not be treated as strong confidentiality protection.

Excel marks cells as locked by default, but that setting only takes effect after you protect the worksheet. For a practical input form, first select the cells people should be able to edit, open Format Cells from the Home tab’s Format menu, select the Protection tab, and clear Locked. Then protect the sheet. For example, in a quote template you could unlock the quantity and unit-price entry cells while leaving the total formula and headings locked. Test the finished sheet by trying to edit both an input cell and a formula cell.

Protect workbook structure

Workbook structure protection is for controlling the sheet tabs, not the contents of every cell. In the Windows desktop app, select Review > Protect Workbook, enable Structure if the dialog offers that choice, enter and confirm a password if desired, and select OK. With structure protected, users are restricted from actions such as inserting, deleting, renaming, moving, hiding, or unhiding worksheets.

This is useful for a workbook whose sheet organization is part of its design—for instance, a monthly reporting file with standardized tabs. It does not stop users from changing unprotected cell values, and it does not prevent someone from reading the sheets. Use worksheet protection as well if you need to limit edits to cells, or file encryption if you need to limit who can open the workbook.

Excel for Mac and Excel for the web

On a Mac, Excel offers password protection, but the menu location differs from Windows. In current desktop versions, look under File > Passwords to set a password to open a workbook. Worksheet protection is available from the Review tab; the exact controls or wording can vary with the Mac release. If you are following Windows instructions and do not see the same menu, check the Mac app’s File and Review menus rather than assuming the feature is missing.

Excel for the web is not a substitute for the desktop app’s file-encryption workflow. Use the desktop version to apply or remove an open password. An encrypted workbook may need to be opened in desktop Excel rather than in a browser. If you collaborate through OneDrive or SharePoint, use the service’s sharing permissions to decide who can access the file; those permissions control access to the cloud item and are separate from an Excel workbook password.

What happens if you forget the password?

For an encrypted workbook, losing the password can mean losing access to the file’s contents. Microsoft does not provide a way to retrieve a forgotten workbook encryption password, and a Microsoft 365 subscription does not create a recovery key for it. Do not assume that Microsoft support, a new copy of Excel, or renaming the file will restore access.

For worksheet or workbook-structure protection, forgetting the password can also make intended changes difficult. These protections are not the same as file encryption, but you should still record their passwords and retain an unprotected backup where appropriate. Before applying any protection to an important workbook, keep a separate copy in a secure location and make sure the password record identifies the correct file and whether the password is for opening, a sheet, or workbook structure.

Safer password and sharing practices

A password is only useful if it is both hard to guess and available to the people who legitimately need it. Avoid names, company names, workbook topics, common phrases, and passwords reused from other accounts. A long, unique password stored in a password manager is generally easier to manage safely than a short password chosen for convenience. Send the password through a different channel from the workbook when practical, rather than putting both in the same email or message.

  • Keep an unprotected working backup in a restricted, secure location if you need one for recovery.
  • Share the password only with people who need access, and update your sharing plan when access changes.
  • Check that the workbook is protected after saving, and test the exact copy you intend to distribute.
  • Use OneDrive or SharePoint access controls when you need to manage who can view or edit a shared cloud file. Those controls complement, but do not replace, encryption of a downloaded copy.

For workbooks containing sensitive personal, customer, or business information, follow your organization’s security and retention rules. A workbook password is one layer, not a complete information-security plan: it does not stop an authorized recipient from copying information after opening the file, and it does not control all copies made outside the shared location.

Common misconceptions and problems

The most common mistake is choosing Protect Sheet when the goal is to stop people from viewing the workbook. Sheet protection controls editing; it does not make the data private. The reverse mistake is encrypting a workbook when several people need to edit it casually: each person must know the opening password, and encryption does not provide fine-grained permissions for individual cells.

If Excel does not ask for a password after you set one, confirm that you used Encrypt with Password, saved the workbook, and reopened the saved copy. If a colleague cannot open the file, check for typing errors, capitalization, and whether they received the latest copy. If a cell remains editable after you protected a sheet, verify that the cell was locked before protection was enabled; cells unlocked for data entry remain editable by design.

Another misconception is that a worksheet password and an opening password provide equal security. They do not. Excel’s worksheet protection is intended to control ordinary editing, while open-password encryption protects access to the file itself. For confidential information, use file encryption and carefully managed sharing, not sheet protection alone.

Frequently Asked Questions

Can I password-protect only one sheet in Excel 365?
Yes. Select that sheet and choose Review > Protect Sheet. This limits selected editing actions on that sheet but does not prevent people from opening the workbook or viewing its contents.

Does protecting a worksheet stop someone from seeing the data?
No. Worksheet protection is an editing control, not file encryption. To require a password to open the workbook, use File > Info > Protect Workbook > Encrypt with Password in Excel for Windows.

Can Microsoft recover a forgotten Excel password?
Microsoft cannot retrieve a forgotten password for an encrypted workbook. Keep a secure password record and a suitable backup before applying encryption.

Can I password-protect an Excel file in a browser?
Use the Excel desktop app to apply or remove an open password. Excel for the web has different capabilities, and an encrypted workbook may need desktop Excel to open.

Is Excel 365 password protection included with Microsoft 365?
The password-protection commands are features of the Excel desktop app, not a separate password-protection purchase. Which Excel apps and services you can use depends on your Microsoft 365 plan and organization’s setup.

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.