How to Password Protect Excel 2007
It is always smart to password protect your Microsoft excel spreadsheets especially when there are too many cooks in the kitchen. The last thing you want is a user on the network tampering with a formula on a huge spreadsheet. In addition it's just smart to use passwords in general to safe guard your work.
Other People Are Reading
Instructions
-
-
1
In this example I will show you how to password protect a whole worksheet or a single worksheet in Microsoft excel 2007. The bottom of the article shows password protect "how to's" for other earlier versions.
-
2
In order to protect your worksheet you have to first enable worksheet protection by going to the REVIEW tab at the top of your document and clicking on PROTECT SHEET or PROTECT WORKBOOK.
-
-
3
From there you should get a window that will enable you to set/enable the password for the worksheet in addition to allowing or disallowing users to certain areas of your workspace.
-
4
If multiple users are accessing your excel document I advise to just to password protect your area of responsibility.
-
1
Resources
More Like This
Comments
-
Sarah Wilson CCRP
Jan 04, 2009
"Too many cooks in th kitchen" lol. I like that. Good advice.
