Require a password to open or modify a workbook

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.

Require a password to open a workbook

  1. Open the workbook that you want to protect.

  2. On the Review tab, under Protection, click Passwords.

    Review tab, Protection group

  3. In the Password to open box, type a password, and then click OK.

  4. In the Confirm Password dialog box, type the password again, and then click OK.

  5. Click Save  Save button .

    Tip: To remove a password, select all contents in the Password to open box, and then press DELETE .

Require a password to modify a workbook

You can add a password so that only authorized users can make changes to a workbook. Users who are not authorized can still open the workbook and then save it by using a different file name.

Note: Unlike workbook element protection, which prevents changes to the structure and windows of a workbook, workbook-level password security helps protect the entire file against unwanted changes..

  1. Open the document that you want to help protect.

  2. On the Review tab, under Protection, click Passwords.

  3. In the Password to modify box, type a password, and then click OK.

  4. In the Confirm Password dialog box, type the password again, and then click OK.

  5. Click Save  Save button .

    Tip: To remove a password, select all contents in the Password to modify box, and then press DELETE .

See also

Protect a sheet

Protect a workbook

Restrict permission to content in a file

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×