Create a Password to Lock and Protect Your Excel Workbook

by Avantix Learning Team | Updated October 30, 2019

Applies to: Microsoft Excel 2010, 2013, 2016, 2019 and 365 (Windows)

You can lock and protect an Excel workbook by adding a password using your security options. If you want to prevent other users from accessing or changing your workbooks, password protection can be added to your Excel files in a number of ways. The easiest option  is to use the File tab in the Ribbon. You can use password protection to add security and prevent other users from opening a workbook, changing a worksheet or altering workbook structure. In this article, we’ll focus on using the File tab (Backstage View) in the Ribbon to enable protection for opening a workbook and/or protecting workbook structure.

Accessing protection options

To access the various protection options in Excel:

  1. Open the Excel workbook you wish to password protect.
  2. Click the File tab in the Ribbon. The Backstage View appears.
  3. Select Info.
  4. Click Protect Workbook or Encrypt with Password and then Protect Workbook. A menu appears. Choose the desired option from the menu.

Microsoft Excel protect workbook button training.

Preventing other users from opening a workbook

To prevent other users from opening a workbook by encrypting a password:

  1. Click the File tab in the Ribbon. The Backstage View appears.
  2. Select Info.
  3. Click Protect Workbook. A drop-down menu appears.
  4. Choose Encrypt with Password. A dialog box appears.
  5. Enter a password in the edit box. Passwords are case sensitive. Be sure to keep your password in a safe place.
  6. Click OK. A dialog box appears prompting you to re-enter the password.
  7. Re-enter the password.
  8. Click OK.

Microsoft Excel enter password dialog.

Close and save the workbook. When a user tries to open the workbook, they will be prompted to enter the password.

Changing or removing a password to open a workbook

To remove an encrypted password to open a workbook:

  1. Open the Excel workbook with password protection. A dialog box appears.
  2. Enter the password and click OK.
  3. Click the File tab in the Ribbon. The Backstage View appears.
  4. Select Info.
  5. Click Protect Workbook. A drop-down menu appears.
  6. Choose Encrypt with Password. A dialog box appears.
  7. Delete the password in the edit box or enter a new password.
  8. Click OK.
  9. If you have entered a new password, enter the password again.
  10. Save the file.

Protecting workbook structure

If you protect workbook structure, you can prevent users from changing, moving or deleting worksheet tabs.

To prevent users from changing the structure of a workbook:

  1. Open the Excel workbook you wish to protect.
  2. Click the File tab in the Ribbon. The Backstage View appears.
  3. Select Info.
  4. Click Protect Workbook or Encrypt with Password and then Protect Workbook. A menu appears. Choose the desired option from the menu.
  5. Choose Protect Workbook Structure. A dialog box appears.
  6. Ensure Structure is checked. Enter a password in the edit box. Passwords are case sensitive. Be sure to keep your password in a safe place.
  7. Click OK. A dialog box appears prompting you to re-enter the password.
  8. Re-enter the password.
  9. Click OK.

Microsoft Excel protect structure dialog box.

Save the workbook. Users will not be able to change, delete, move or unhide worksheet tabs.

Removing a password to protect workbook structure

To remove a password to protect workbook structure:

  1. Open the Excel workbook with password protection.
  2. Click the File tab on the Ribbon. The Backstage View appears.
  3. Select Info.
  4. Click the Protect Workbook button. A menu appears.
  5. Choose Protect Workbook Structure. A dialog box appears.
  6. Delete the password in the edit box. Passwords are case sensitive.
  7. Click OK.
  8. Save the file.

There are many more strategies for securing workbooks including creating digital signatures or using third party programs. You can also protect a worksheet in a workbook.

Subscribe to get more articles like this one

Did you find this article helpful? If you would like to receive new articles, join our email list.

To request this page in an alternate format, contact us.

Recommended Microsoft Excel training

Microsoft Excel: Intermediate / Advanced

Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools

Microsoft Excel: Introduction to VBA (Visual Basic for Applications)

VIEW MORE COURSES >

Copyright 2020 Avantix® Learning Inc.

You may also like

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca

Summary
How to Lock and Protect an Excel Workbook with a Password
Article Name
How to Lock and Protect an Excel Workbook with a Password
Description
You can lock an an Excel workbook with a password so that other users cannot open or edit it. You can use password protection to add security and prevent other users from opening a workbook, changing a worksheet or altering workbook structure.
Author
Publisher Name
Avantix Learning Inc.

Pin It on Pinterest

Share This