Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

You can help prevent unauthorized users from opening or modifying a workbook file, even if they have permission to open it.

Caution: When you create a password for a workbook, write down the password and keep it in a secure place. If you lose the password, you can't open or gain access to the password-protected workbook.

  1. Open the sheet or workbook that you want to protect.

  2. On the Review tab, click Protect Sheet or Protect Workbook.

    Password protection buttons

  3. In the Password box, type a password, and in the Verify box, type the password again.

  4. Choose any other protection options you want and click OK.

  5. Click Save.

    Tip: To remove a password, click Unprotect Sheet or Protect Workbook and enter the password.

See also

Protect a sheet

Protect a workbook

Restrict permission to content in a file

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!