How to Password Protect an Excel File When Opening

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.

...
Protect the data in your Excel spreadsheets by password protecting them.

Step

Open the Excel file that you intend to password protect.

Step

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

Step

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

Step

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