Microsoft Excel: How to Encrypt a Workbook

Encrypting a workbook helps to protect workbooks that include sensitive information.  This knowledge article demonstrates how to encrypt a Microsoft Excel 2016 workbook.

Step 1

Access the protection settings in Microsoft Excel 2016 by opening the file and selecting the File tab.

Title: File tab in Microsoft Excel 2016

Step 2

Select Info from the File menu.

Title: Info option on File tab in Microsoft Excel 2016

Step 3

Select the small arrow within the Protect Workbook icon, then select the option to Encrypt with Password.

Title: Info option on File tab in Microsoft Excel 2016 Description: Protect Workbook dropdown menu options: Mark as Final; Encrypt with Password; Protect Current Sheet; Protect Workbook Structure; Restrict Access; Add a Digital Signature.

 

Print Article