How do I password protect an Excel workbook?

How to do I password protect an Excel workbook?

(Applies to Microsoft Excel 2010, 2013 & 2016)

Once an Excel workbook is encrypted with a password anyone that attempts to open it in the future will need to enter the password in order to view or edit the contents.

There are no restrictions on the passwords you use with regards to length, characters or numbers but passwords are case-sensitive.

Passwords should be stored in a secure register to avoid the situation where workbooks cannot be opened because passwords have been forgotten or the original author has exited the organisation.

  1. Open the workbook that you wish to password protect.
  2. Select File and then choose Info.

  3. Select the Protect Workbook box and choose Encrypt with Password.

  4. Type a password in the Encrypt Document dialogue box and then select OK.
  5. Confirm the password in the Confirm Password dialogue box and then select OK.

  6. When you attempt to open a password protected workbook a dialogue box will be displayed requesting the password be entered before the contents will be displayed.

  • 12
  • 21-Nov-2018