Protecting workbook elements

Excel 2016 2013 2010 2007 2003
Protecting a workbook is different from protecting the Excel file with a password to prevent reading/writing or locking the spreadsheet elements to prevent editing. Workbook protection forbids other users to add, move, rename or delete worksheets and defends against viewing hidden worksheets or hiding worksheets.

To protect Excel workbook elements, on the Review tab, in the Protect group, click the Protect Workbook button:

Protect Workbook button in Excel 365

In the Protect Structure and Windows dialog box:

Protect Structure and Windows in Excel 365
  • To prevent other users from removing workbook protection, in the Password (optional) box, type a password, click OK, and then retype the password to confirm it.

    Note: The Password is optional. If you don't supply a password, then any user can unprotect the workbook and change the protected elements. Make sure that you choose a password that you can remember because if you lose the password, you cannot gain access to the protected elements in the workbook.

  • In the Protect workbook for group:
    • The Structure option is checked by default, prevents users from:
      • Viewing spreadsheets that you have hidden
      • Moving, deleting, hiding, or changing the names of spreadsheets
      • Inserting new spreadsheets or chart sheets (Note: Users will be able to insert an embedded chart to an existing spreadsheet)
      • Moving or copying spreadsheets to another workbook
      • In PivotTable reports, displaying the source data for a cell in the data area, or displaying page field pages on separate spreadsheets
      • For scenarios, creating a scenario summary report
      • In the Analysis Tool Pack, using the analysis tools that place results on a new spreadsheet
      • Recording new macros (Note: If you run a macro that includes an operation that can't be performed in a protected workbook, a message appears and the macro stops running).
    • The Windows option is available only in Excel 2007, Excel 2010, Excel for Mac 2011, and Excel 2016 for Mac, keeps workbook windows in the same size and position each time the workbook is opened.

Workbook protection in Excel isn't a security feature, and you shouldn't use it as a means of protection of the intellectual property. There are many commercial password-cracking tools for Excel, and it won't take long to crack your password. However, protecting the structure of worksheets and hiding some sheets of analytical reports and surveys protects from “curious” users and irrelevant questions.

See also this tip in French: Comment protéger les éléments de classeur Excel.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more