Buzz
Similar to Microsoft Word, Microsoft Excel is the most widely used spreadsheet software today. In this article, we introduce how to set a password to protect Excel files using the built-in feature in Microsoft Excel.
Tutorial: Setting Password for Excel File
For Microsoft Excel 2010:
Step 1: Open the Document
Step 2: Set a Secure Password for the File
- On the toolbar, select File, then choose Protect Workbook, and click Encrypt Password
- Enter the password to protect the file
- Re-enter the password to protect the file
After setting up the password, now if someone wants to open your document, they must enter the correct password to access it, as illustrated below:
For Microsoft Excel 2007:
Step 1: Open the file
Step 2: Choose the Microsoft Excel icon --> Save as. The Save as dialog box appears, then proceed:
+ Enter the file name you want to set a password for, or keep the current name if you prefer
+ Select Tool --> General Options
Step 3: Set a password for the file
The General Options window provides various options depending on your usage purpose, allowing you to set passwords for your files:
- Password to open: Set a password to open the file (You need to enter this password to open the file)
- Password to modify: Password to edit the file (This setting prevents others from editing your file )
You can choose to set a password to open the file, set a password to modify the file, or set both types of passwords.
Step 4: Re-enter the password
Finally, we also achieve similar results as above.
