How to Password Protect an Excel File When Opening

Written by angela m. wheeland Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Password Protect an Excel File When Opening
Protect the data in your Excel spreadsheets by password protecting them. (Jupiterimages/Brand X Pictures/Getty Images)

Many individuals and businesses use Excel spreadsheets to calculate and monitor sensitive financial information. Microsoft Excel contains many features to protect the data in a worksheet. Password protecting a spreadsheet requires a password to open and modify a spreadsheet. To password protect your Excel file you must encrypt the spreadsheet. Encrypting a spreadsheet converts the text of the document to an unreadable format. Upon entering the password, Microsoft Excel converts the document to its original format, allowing the user to view the information in the spreadsheet.

Skill level:


  1. 1

    Open the Excel file that you intend to password protect.

  2. 2

    Click the "File" tab and click "Info."

  3. 3

    Click "Protect Workbook" and then click "Encrypt with Password."

  4. 4

    Enter a password and click "OK." The password is active immediately.

Tips and warnings

  • If you lose the spreadsheet password, Microsoft cannot help you retrieve it. Keep the password in a safe place.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.