Excel 2007 | Passwords – Where Did That Option Go?

 If you’re anything like me, you probably got lost trying to find the basic things in Excel 2007. Creating passwords for my worksheets was one of the many things I couldn’t find in this new program. Well, stress no more. Here it is! Who knew they would hide it under “Save As”? 

 

 

As always, let us know if there are things you need help with. You can receive these updates automatically through email by clicking below:

Subscribe to admins4admins.com by Email

 

 

HOW TO FIND THE PASSWORD OPTION IN EXCEL 2007

1. Click the “Microsoft Office” button.

2. Select “Save As”.

3. Click on “Tools”.

4. Then select “General Options”.

5. You can assign both passwords — one to access the file and one to provide specific reviewers with permission to modify its content. Make sure each password is different from each other.

6. When prompted to “Reenter password to proceed”, retype your password then click “OK”

 7. Click “Save”.

 

How do I put a password on an Excel 2007 workbook(PDF)