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

How to Delete a Pivot Table in Excel

How to Delete a Pivot Table in Excel

A pivot table can be deleted in an Excel workbook in several ways. You can delete a pivot table, convert a pivot table to values or clear data and customizations from a pivot table to reset it. When a pivot table is created from source data in a workbook,

How to Change Commas to Decimal Points and Vice Versa in Excel (5 Ways)

How to Change Commas to Decimal Points and Vice Versa in Excel (5 Ways)

Depending on your country or region, Excel may display decimal points or dots instead of commas for larger numbers. The decimal point (.) or comma (,) is used as the group separator in different regions in the world. You can change commas to decimal points or dots or vice versa in your Excel workbook temporarily or permanently.

How to Group by Month and Year in a Pivot Table in Excel

How to Group by Month and Year in a Pivot Table in Excel

You can group by month, year or other date period in a pivot table in Excel. One option is to group by date periods in a pivot table using the Grouping feature. Alternatively, you can also create calculations in source data to extract the month name and the year from a date field and use the fields in your pivot table.

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