Microsoft Excel Training Videos

Password protection encryption in Excel of certain data

You need password protection encryption in Excel if you have files in Excel that you don't want other people to access or maybe only a few trusted persons should be able to read the contents and maybe you wish only the relevant persons should be allowed to modify the file.
If you create a situation where the person requires a password to open that Excel workbook and view its data, you help make your file safer and more secure. A password is not of much use if just anyone can guess it. You need a strong password. What's a strong password, and how do you choose one?
To create a strong password in Excel, Microsoft recommends the following strategy:
Strong passwords:
  1. Are at least seven characters long.
  2. Include both uppercase and lowercase letters, numbers, and a symbol character between the second and sixth position.
  3. Look like a random collection of characters. Don't use numbers that look random but are really your birthday, your spouse's birthday, or your auto license. All these are guessable.
  4. Have no repeated characters.
  5. Have no characters that are consecutive, such as 1234, abcd, or qwerty.
  6. Do not contain patterns, themes, or complete words (in any language).
  7. Do not use numbers or symbols in place of similar letters — for example, $ for S, or 1 (the numeral) for l (the letter).
  8. Do not use any part of your user name for logging on to the Internet or a network.
  9. Change passwords frequently — at least every one to three months.
  10. When you replace a password, make sure it's totally different from the previous one and do not reuse any portion of the old password.
How to protect your file in Excel from prying eyes
On the File menu, click Save As.
In the Save As dialog box, click Tools, and then click General Options to open the Save Options dialog box.
You have the option to create 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, no changes can be made to the file. If you give a person both passwords, changes can be made to the file.
In the advanced options you can encrypt the Excel file contents. Encryption is a method of converting information into a coded form. If an unauthorized person tries to view the file, the data in the file is seen as garbled characters and symbols. When you enter a Password to open, both the password and the contents of the workbook are encrypted. There are different encryption types that you can choose that offer different levels of security. We have selected the default 'Office 97/2000 Compatible' as shown in the Excel training video so that people who use Microsoft Office 97 or Office 2000 can open the workbook.
More about password protection in Microsoft Excel
Password protection encryption in Excel