Cart 0

How to Protect an Excel Workbook

Posted by Roger Hyttinen on

You can protect the structure of your Excel workbooks from being altered by applying Workbook Protection. For example, you can prevent users from adding, hiding, deleting, renaming, unhiding, moving or copying worksheets. Additionally, you can set an option that locks the window size and location of a worksheet so that it cannot be altered by users.

Protect Workbook Structure dialog

To Protect a Workbook

1. Click the Review tab on the Ribbon.
2. Click the Protect Workbook button on the Changes group.

Protect Workbook icon

3. Select Structure to prevent the physical modification of the workbook.
4. Select Window to prevent changes to the size and position of the workbook window.
5. Enter a password in the Password text box.
6. Click OK.
7. Reenter password in the confirm password box.
8. Click OK

Tip: There is another way to password protect the structure workbook, which allows you to specify a password necessary to modify the workbook. Click the File tab > Info, click the Protect Workbook icon in the center pane and then click Protect Workbook Structure. Enter the password necessary to modify the file.

Looking for more Excel tips? Check out our new book Excel 2016: Up To Speed available as an ebook on Amazon, Kobo, and Apple iBooks


Share this post

← Older Post Newer Post →

Leave a comment

Please note, comments must be approved before they are published.