Password Protect On Excel 2007

By: Dwayne Dockery

Break Studios Contributing Writer

There are a lot of reasons why one might need to password protect on Excel 2007spreadsheets. Many companies and organizations have vital information on these spreadsheets, not to mention information that shouldn’t be revealed to just anyone, such as sales figures and personal information. As with all documents of this nature, they should be password protected, and the following guide is meant to show step by step exactly how to do this.

You will need:

  • computer
  • Microsoft Excel software
  1. Create a new document, or open an existing one in the Excel 2007 screen, by first pressing the Microsoft Office button, and choosing New or Open. In older versions of Microsoft Office, you may have to press File. As with all Windows programs, there are shortcuts to do almost everything in the work space. To open or create a file with a shortcut, press F12.
  2. Once you have the document open on your desktop, and you’ve decided to save it, click on the Microsoft Windows button in the upper left hand corner of the screen again. Choose "Save As," and when the window pops up, in the lower part of the window you’ll see a button named "Tools." Click it and a scroll down box will appear with several options. Choose "General Options."
  3. Inside of the "General Options" window that pops up, you can choose either to "Password Protect Upon Opening," "Upon Modifying," or both. At this point, a password can be typed in either of the text fields.
  4. After a password is chosen, there is a checkbox below the password fields, which will allow the user to make the document read only. At this point, if all of the desired actions have been taken, then it’s all right to press "OK."
  5. When the "OK" button is pressed, there will be a prompt to “Re-Type Password.” Simply enter the password again, and press "OK" again. Just remember that all passwords are case-sensitive, and must be typed in exactly as the original password was typed.

The process is finished, and the document is now safe from prying eyes, and now everyone will know how to password protect their Excel 2001 documents.

Posted on: May. 11, 2011