In today’s world where every digital data and profile that you create is password protected then why not protect your Excel File as well. If you are working on top management data or some other sensitive information, you want that file to be secured. With MS Excel you can encrypt your excel file such that it requires a password to open or modify data. Let’s see how
Password Protect to Open
To Encrypt your excel file such that it required a password to open the file you need to go to:
File → Info → Protect Workbook → Encrypt with Password
Excel will ask you to set a password and then reconfirm the password. And voila your file is now password protected!! Next time when you open the file it will ask you to enter the password to open it.
Password Protect to Modify
Nowadays most of the company have a common shared drive among its employees, and they insist on keeping all the work files in that shared drive. In such a scenario, sometimes it is required that the file is to be used by many users. However, not all users are required to modify the file i.e. some use those files only to access information. In these cases, in order to prevent a file from accidental modification, you can encrypt a file such that it asks for a password to modify the file.
In order to encrypt your file such that it asks for a password to open and/or modify you need to go to
File → Save As → Select the Folder where you want to save your file
Under Tools Select General Options
In the given dialog box select if you want to give a password to open or modify or both. You can prompt users to open as a read-only file by selecting the Read-only recommended check box.
Reconfirm your Passwords.
- Microsoft cannot retrieve forgotten passwords, so be sure that your password is especially memorable.
- There are no restrictions on the passwords you use with regards to length, characters or numbers, but passwords are case-sensitive.
- You can apply the same procedure to password protect any Microsoft Office applications such as Word, Powerpoint, Publisher etc.