Imagine that after working the entire day on a glorious spreadsheet that will be the talk of the day, you decide to save it in a network drive. On the next morning you discover that one of you colleagues reviewed the spreadsheet and unintentionally messed up some of your formulas…
You can easily avoid those situation by password protecting your spreadsheets. As almost everything related to Office 2007, password protecting is easy but very different than in previous versions.
Here is the quick process:
- Create your Excel 2007 spreadsheet.
- Click the Microsoft Office Icon.
- Click Save As and pick Excel Workbook.
- Click 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.
Note: If you lose or forget your password you won’t 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.
Feel free to look into these related tips:
- How to use the Microsoft Excel IF formula ?
- How to change your Facebook password?
- How to Open Office 2007 documents using earlier Office versions?
Posted by Gili
Like this post? Become a regular and share it with others!
It is required for every file to be paswd protected. Thanx for the Tip
No probs, thanks for visiting.
Gili
Thank you!
Is is possible to enable password on tabs within the spreadsheet? Also, is this still possible if the sheet will be published on Web page?
great help , THANKS
i have old password but i want to change mu password in excel 2007 file