Password Protect Excel Files

Add to Favorites
Author:

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

Question? Ask it in our Excel Forum


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

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...
Guide to Referencing Other Excel Files with Formulas and Functions
Tutorial: Your guide to making cross-workbook formulas and functions. This includes an overview of p...
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 ...
Require a Password to View Hidden Worksheets in Excel - VBA Tutorial
Tutorial: Full Course A simple macro that allows you to require a password in order to view hidden ...
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'...