How to Set a Password on Excel 2007

Save

Passwords are useful to prove identity and authenticate yourself when dealing with computer files. To encrypt and protect your Microsoft Excel 2007 spreadsheet data, you may set a password and save it. You may set your password up to 255 characters long. The next time you open the spreadsheet, Excel will prompt you to enter your password. Make sure you remember your password because Excel does not have a password recovery option. If you lose or forget your password, you will not be able to access the data in your spreadsheet.

  • Open the Excel spreadsheet to which you want to add a password. Click the Microsoft Office Button, select "Save" and select a location to save the spreadsheet.

  • Click the Microsoft Office Button, select "Prepare" and choose "Encrypt Document" from the list. An "Encrypt Document" dialog box appears.

  • Enter a password into the text box and click "OK." Confirm the password on the next menu by entering it again into the text box and click "OK." If you entered the password correctly, the dialog box will disappear. Save the spreadsheet again.

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!