Password protection encryption in Excel of certain data
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:
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.
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.