Sunday, December 9, 2012

\\Password Protect an Excel 2007 Worksheet//

Whether you use Excel at work, or at home, this tip can really be handy!  Password protecting your worksheet is a good way to make sure no one gets in and messes up the formulas that you tweaked out!

Password protecting is easy but  different than in previous versions of Excel.
Here are the steps in a nutshell:
  • Open or create the Excel 2007  worksheet
  • Click the Microsoft Office Icon.
  • Click Save As and pick Excel Workbook.
  • Click the down arrow on the  Tools button (in the lower left side of the Save as prompt).
  • Click General Options.
  • Set a password to open and modify your spreadsheet.
  • Click OK and reenter your password.
Make sure you use a secure password, but more importantly, make sure you use a password you will remember!
If you lose or forget your password you will not be able to recover it.
Make sure that you keep the password in a safe place.
A similar procedure applies to other Office 2007 documents such as PowerPoint presentations and Word documents.

0 comments:

Post a Comment