Posted on 12 August 2021

Top Tip Thursday: Password protecting your Excel spreadsheets

Contact us

Encrypting an Excel spreadsheet with a password is a really simple yet effective way to maintain control over who has access to the information within a specific document. This week’s Top Tip therefore (you guessed it) covers how to password protect Excel spreadsheets.

Whether it’s highly sensitive data, a confidential project or personal information you’d rather to hide, a password protected Excel workbook will restrict access, providing you with full control.

To do so, you need to:

  1. Choose between Protect Workbook or just Protect Sheet under the Review
  2. Create a password in the Password If you are struggling to generate a strong password, check out our 5 top tips for secure passwords article to strengthen your security.
  3. If you chose Protect Sheet, you can choose from a list what users of the worksheet are allowed to do.
  4. Click OK, re-enter the password to confirm, and then press OK

You will know that your workbook is password protected if the Protect Workbook button is highlighted. To know if a specific sheet is protected, there should be an Unprotect Sheet option.

Here to help

If you would like to enhance your online security, develop your Microsoft skills or supercharge your systems, get in touch with us at [email protected]. We’re help to help!