How To Protect An Excel 2016 Workbook

We can easily protect a sensitive or a confidential Workbook, either by assigning a password, either restricting access to it avoiding unwanted editing. We can also protect a document from being opened. As mentioned in a previous post of mine Protect A Word 2016 Document, the same procedure stands here, with the difference that some commands might be not available or some more will be available. All we have to do is to follow the steps below.

Fist we must select the File tab in order to move to backstage view as shown in the image below. Once in backstage view we make sure that the Info category from the left is selected. Then from the middle of the drop down menu we notice three different categories which are the following:

  • Protect Document: Control What Types Of Change People Can Make To This Workbook.
  • Inspect Document: Before Publishing This File Be Aware Of Its Contents: Author’s Name and Absolute Path
  • Manage Document: Check Out Document Or Recover Unsaved Changes.
  • Browser View Options: We Can Pick What Viewers Can See When This Workbook Is Viewed On The Web

Backstage View - Info

For this post, I will select the Protect Document command as shown in the image below. The drop down menu appears with the following commands available:

  • Mark As Final
  • Encrypt With Password
  • Protect Current Sheet
  • Protect Workbook Structure
  • Restrict Access
  • Add A Digital Signature

In the image below I have selected the command Mark As Final. By using this command, we can let readers know that the Workbook is final and make it read-only. Once selected, a warning dialog box will appear, notifying us that this Workbook will be marked as final and then will be saved. All we have to do is to press the Ok button and the document will be marked as final.

Mark As Final

In the image below I have selected the command Encrypt With Password. By using this command, the Encrypt Document dialog box will appear where we will have to type and retype our Password in order to Encrypt the Workbook. We are notified that if we forget our Password, we can’t recover our Workbook.

Encrypt With Password

In the image below I have selected the command Protect Current Sheet. By using this command, we can control what types of changes people can make to the current sheet.

Protect Current Sheet

Once selected the Protect Sheet dialog box appears, where we activate or deactivate what we need to protect in the Worksheet. We can even assign a password in order to unprotect the sheet.

Password To Unprotect Sheet

In the image below I have selected the command Protect Workbook Structure. By using this command, we prevent unwanted changes to the structure of the workbook, such as adding sheets to it.

Protect Workbook Structure

Once selected the Protect Structure and Windows dialog box appears, where we just press the Ok button in order to protect the Structure for our Workbook.

Protect Structure And Windows

In the image below I have selected the command Restrict Access. By using this command, we can grant people access while removing their ability to edit, copy or print. We can either select Unrestricted Access, Restricted Access, Confidential and Confidential View Only.

Restrict Access

Once selected, the Permissions dialog box will appear as shown below where we do all the necessary adjustments. Once finished we just press the Ok button in order to return to our Workbook and the changes to take place.

Permission

In the image below I have selected the command Add A Digital Signature. By using this command, we can ensure the integrity of the Workbook by adding an invisible digital signature.

Add A Digital Signature

By selecting this command, the Sign dialog box appears, where we do all the appropriate adjustments in order to Digitally Sign our Workbook.

Sign In Dialog Box

The procedure of Protecting our Workbook is quite simple. The fact is that by protecting it, we feel much safer that our sensitive or a confidential data won’t fall in the wrong hands.

Below you can check out the video describing How to Protect an Excel 2016 Workbook in ways that is up to you to choose.

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on September 20, 2016, in Excel 365 English, Microsoft Office 365 ProPlus English and tagged , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on How To Protect An Excel 2016 Workbook.

Comments are closed.