Page 4 of 32PREVNEXT

Help secure and protect data in Excel

Save Options dialog box and the Security tab

Fig. 1  When you save a file, you can create passwords in the Save Options dialog box.
Fig. 2  You can create the same passwords on the Security tab in the Options dialog box.

You have the option to create not one, but two passwords:

  • You can type a password in the Password to open box. That's the password you'll use to open the file.
  • You also have the option to type a password in the Password to modify box. You should create this second password if you intend to give the Password to open to others, but you don't want them to be able to change the contents of the file.

Note      A Password to modify helps prevent people without the password from saving their changes in your original document, but it does not stop them from making changes and then using the Save As command to save the document as a new file with a different name.

If someone has the Password to open but not the Password to modify (if you've created that password), no changes can be made to the file. If you give a person both passwords, changes can be made to the file.

Tip     If you don't want just anyone to access your data when you leave your computer, you can lock your computer by pressing CTRL+ALT+DELETE, and then clicking Lock Computer, if your computer is on a domain. When you return, press CTRL+ALT+DELETE again and then enter your computer password to unlock your computer.

Page 4 of 32PREVNEXT