Password Protect Excel Files

Add to Favorites

How to keep an Excel workbook safe by encrypting it with a password.

This will make it so that a user cannot open the Excel file unless they have the correct password.

Steps to Encrypt a Workbook with a Password in Excel

  1. Click the File button ( in Excel 2007 this is the Office button):
    c78bfad88cc9bfc2dd16da80f48de178.jpg
  2. Go to the Info tab (in Excel 2007 this is the Prepare tab):
    d33dfce105ef074a3b74fc308c7eccff.jpg
  3. Click the Protect Workbook button (in Excel 2007 this is the Encrypt Document button):
    2864decc93f5a089e01cc786648edec7.jpg
  4.  Click the Encrypt with Password option (this step not needed for Excel 2007):
    9c6f8f7f4bf96d4e79564791a5b45dda.jpg
  5.  Enter the password that you want to use to open the Excel file and hit OK:
    9f910e6bf61f12b27f0dd6140f5bb1a4.png
  6. You will need to re-enter the password and hit OK again:
    3d11faf4a310972566090f81c1f07f6d.png
  7. That's it:
    c1efa545df5468212a38822b5fa7c8e8.jpg

Steps to Encrypt an Excel 2003 File

Tools > Options > Security tab > Password to Open > enter the desired password required to open the Excel file.

Notes

USE A PASSWORD THAT YOU WILL REMEMBER!!!

Do not come to us to ask for help removing the password from an Excel file!!!

Sample Workbook

We included a sample Excel file for this tutorial that has been password protected.  You can download it and see what it's like to use this feature.

The password is: 123456

(do not ever use this as a password for your files - this was done here to make it easy for you to use)


Downloadable Files: Excel File

Similar Content on TeachExcel
Password Protect Excel VBA Macros
Tutorial: How to password protect VBA code and macros in Excel so that a user cannot see the code o...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Allow Only Certain People to Edit Specific Cells in Excel
Tutorial: How to allow only certain people to edit certain cells or ranges in Excel. This is a sec...
Prevent a User from Changing Any Data in Excel
Tutorial: I'll show you how to lock a spreadsheet so that nothing can be changed in it. This is a ...
Protect and Unprotect All Worksheets at Once
Macro: This will allow you to protect or unprotct all worksheets in a workbook at once. It doesn'...
Automatically Lock Certain Cells in Excel using a Macro
Tutorial: This macro allows you to have a cell automatically locked after a user enters something in...