See all How-To Articles

How to Protect an Excel Workbook’s Structure

This tutorial demonstrates how to protect the structure of a workbook in Excel.

 

protectstructure protected

 

Protect Workbook Structure

Protect From the Ribbon

  1. In the Ribbon, select Review > Protect Workbook.

 

protectstructure ribbon

 

  1. If required, you can enter in a password. Try and make this as complicated as possible.

 

protectstructure password

 

Note: Protect Windows is no longer supported in the newer versions of Excel.

  1. If you have entered a password, click OK, and then reenter the password.

 

protectstructure reenter password

 

Your workbook structure is now protected. You will not be able to insert, delete, rename, move, or copy sheets. You also will not be able to change the tab color or hide and unhide sheets.

Protect From Backstage View

  1. In the Ribbon, click File > Info > Protect Workbook.

 

protectstructure info

 

  1. Select Protect Workbook Structure.

 

protectstructure protect info

 

You can now enter your password if required and click OK to protect the structure of the workbook.

Protect Google Sheets Workbook

You cannot protect the structure of a Google Sheets workbook as it is done in Excel, but you can add some security in place to individual sheets and ranges.

You can prevent someone from editing the contents of a sheet or range of cells by protecting sheets or ranges.

  1. In the Menu, select Data > Protect sheets and ranges.

 

protectstructure gs protectrange

 

  1. Click Add a sheet or range.

 

protectstructure gs setrange

 

  1. Select the range you require and then click Set permissions.

 

protectstructure gs range

 

  1. You can either restrict the editing to certain users, or you can select to just show a warning when the protected range (or sheet if you have selected to protect the entire sheet) is edited by anybody.

 

protectstructure gs permissions

 

  1. If you do, and then edit the range of cells, you get a warning message!

 

protectstructure gs edit warning

 

Note that adding sheet protection to a Google Sheets file can prevent the user from deleting the sheet, renaming the sheet, or changing the tab color, but it will not prevent the user from copying the sheet within that file or to a new file, or inserting any new sheets into the Google workbook.