How to protect your Excel document with a password

Want to prevent others from opening your Microsoft Excel document? Here is a quick tutorial on how to encrypt a Microsoft Excel document with a password.

How to encrypt an Excel document

Microsoft Office is the most popular productivity software on the planet. It has all the features that you will need for your office workflow. And one of the basic key features is the ability to encrypt a document so only the authorized people who have a password can access the document.

The process of the encryption is really simple and require only a simple password that you can use whatever character length or complexity you prefer. However, you should use a long and more complex password if you want to make sure that the password is uncrackable with a brute-force attack technique.

Today, we will show you how to encrypt a Microsoft Excel document with a password.

Important If you lose or forget the password, it cannot be recovered, It is advisable to keep a list of passwords and their corresponding document names in a safe place.

  1. How to encrypt a new Excel document
  2. How to encrypt an existed Excel document
  3. How to verify the encryption

1 How to encrypt a new Excel document

If you want to set a password for a new Excel workbook document:

  1. Open Microsoft Excel
  2. Choose a document template or a Blank workbook.
    Create a new black Excel workbook
  3. Go to the File menu.
    Open Excel File Menu
  4. Go to InfoProtect Document and select Encrypt with Password.
    Encrypt an Excel workbook with a password
  5. You will need to type a password and click OK.
    Enter a new Password
  6. Re-enter the same password and click OK again.
    Re-Enter the Password
  7. Now your document is encrypted with a password as you can notice the yellow box below:
    The Excel workbook is encrypted
  8. You can now save your document and continue editing your workbook.

2 How to encrypt an existed Excel document

It isn’t much different from the new document encryption. To encrypt an existed Excel document:

  1. Open your existed Excel document.
  2. When the workbook is loaded go to the File menu.
    Open Excel File Menu
  3. Go to InfoProtect Document and select Encrypt with Password.
    Encrypt an Excel workbook with a password
  4. You will need to type a password and click OK.
    Enter a new Password
  5. Re-enter the same password and click OK again.
    Re-Enter the Password
  6. Now your document is encrypted with a password as you can notice the yellow box below:
    The Excel workbook is encrypted

Important You will need to save your document in order to apply the encryption to your Excel document.

3 How to verify the encryption

Now your document is protected with a password. To make sure the document is protected:

  1. Open the protected Excel document.
  2. You will see a Password popup as below.
    Type the Password and click OK to pen Excel workbook
  3. Type your password and click OK to gain access to the document.