DISCOVER
×

How to Password Protect an Excel File When Opening

Updated March 20, 2017

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.

Open the Excel file that you intend to password protect.

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

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

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

Warning

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

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Angela M. Wheeland specializes in topics related to taxation, technology, gaming and criminal law. She has contributed to several websites and serves as the lead content editor for a construction-related website. Wheeland holds an Associate of Arts in accounting and criminal justice. She has owned and operated her own income tax-preparation business since 2006.