How to protect spreadsheets

Excel 2013 2010 2007 2003
You can significantly reduce the number of errors in data entry in Excel by protecting changes of specific spreadsheets (worksheets) and cells.

On the Review tab, in the Changes group, choose which part of your Excel document you want to protect: a particular spreadsheet or the workbook. You can also choose to protect and share your workbook.

Changes group in Excel 2016

   1.   If you choose Protect Sheet, you'll see the dialog box:

Protect Sheet in Excel 2016

Here you can enter a password to unprotect the sheet, and then choose from the long list provided which actions you're willing to allow users of the spreadsheet to perform. For more details see Protecting spreadsheet elements.

   2.   With Protect Workbook you can protect elements of each spreadsheet, you can protect structure of the sheets in the workbook, prohibiting renaming, moving and other operations.

Protect Workbook in Excel 2016

For more details see Protecting workbook elements.

   3.   With Protect and Share Workbook, Share Workbook and Track Changes you can easily work together on workbooks and monitor who, when and what changes made. E.g., track project status and tasks.

For more details see Share workbook and track changes.

   4.   Allow Users to Edit Ranges offers the ability to assign user-level permissions to different areas on a protected spreadsheet. You can specify which users can edit a particular range while the spreadsheet is protected. As an option, you can require a password to make changes.

For more details see Allow specific users to edit ranges in a protected spreadsheet.

See also this tip in French: Comment protéger les feuilles de calcul.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.