« The Best Project Managment tool...ever? | Main | Do you still use iGoogle? »

Password Protect a Spreadsheet

Have you ever had a spreadsheet where you wanted to share the information but you didn’t want anyone else to modify its contents?  Password protection might just be the way to go.  And, it’s simple!

E_iconTo password protect a spreadsheet, all you have to do is:

  1. Select Save as from the Excel Office Ribbon
  2. Click the Tools button below the left-hand pane
  3. Select General Options
  4. Type in a password in the Password to Modify field
  5. Type in same password as a confirmation.
  6. Save the file.


The next time anyone launches the spreadsheet, they’ll be greeted with the following screen.

Password_protect


If you created the spreadsheet and want to modify it, type in the password.  Everyone else will have “Read” access and won't be able to modify it.

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

The comments to this entry are closed.