<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=289291844809425&amp;ev=PageView&amp;noscript=1">
Less Is More Blog Productivity Tips

Join us at the Webinars


Click for our Webinars Schedule.

The Perfect 15-Minute Day Method is here!


Order the book, eBook, journal, or eCourse to get started right away and inject a healthy dose of accomplishments and happiness in your workday and beyond!

Learn more!

Get Our Free eBook

The Results Curve: How to Manage Focused and Collaborative Time

Less-Is-More Blog by Pierre Khawand

Question & Answer: How do I set a password to protect my Microsoft Excel Workbook?

Posted by Pierre Khawand on Sun, May 02, 2010 @ 05:55 PM

If you would like to password protect an Excel workbook, the process is easy and it is the same process by which you can also protect other Microsoft Office documents such as Microsoft Word and Microsoft PowerPoint. The steps below demonstrate how to assign a password for opening and for modifying an Excel workbook.

Please note while the steps below illustrate the process in Microsoft Excel 2007, the steps are pretty much the same in Microsoft Excel 2003 and even Microsoft Excel 2010. 

First: After you save your document, use the Save As option from the Office Button menu to open the Save As window.

Excel 2007 Password Protect

Second: In the Save As window, click on the drop down arrow next to the Tools button that is near the Save and Cancel buttons as illustrated below.

Excel 2007 Password Protect

Third:  Then from the list of options, select the General Option to get the General Options window:

Excel 2007 Password Protect

You can provide two different passwords, one for opening the document, and one for modifying the document. This allows you to provide certain people the ability to view the document but not edit it, while allowing only designated people to edit the document.

You will then be prompted to confirm the passwords you have entered, and then once you confirm, and save the document, you will also be prompted to confirm that you want to replace the existing document, in which case you want to click Yes to confirm.

One word of caution though: "keep the password in a safe place."

Additional Resources

The Microsoft Excel Techniques workshop (see upcoming Webinar on May 11, 2010)

Topics: Microsoft Office 2007, Microsoft Excel Tutorial