Password protection is the best protection nowadays. People protect their important Excel sheets using a password. These protections are used so that any unauthorized person could not temper the data in excel sheet. Sometimes you don't want your user to modify the data in the worksheet but you only want him to go through the readings, so you use Excel sheet Protection. Say you own the team status report worksheet, where you want team members to add data in specific cells only and not be able to modify anything else. With worksheet protection, you can make only certain parts of the sheet editable and users will not be able to modify data in any other region in the sheet. Now the question arises that how to protect a worksheet in ExceL ? Answer to this simple question has been described in the section below.
First of all, let’s see what is Worksheet Password Protection? Worksheet password prevents the user from changing, moving, or deleting data in a worksheet. With worksheet protection, you can make only certain parts of the sheet editable and users will not be able to modify data in any other region in the sheet.
Part 1. Using Excel 365, Excel 2016, Excel 2013, Excel 2010, Excel 2007:
Only Excel 2003 password protection method is different. After Microsoft Excel 2003, Password protection has been improved and has been made easy. A password prevents other people from removing the worksheet protection—it needs to be entered to unprotect the sheet. Now using a couple of clicks you can Protect your Excel Sheet. Just follow the steps below and in no time your sheet will be protected and ready to deliver.
1. Open the Excel Document that you want to protect with any of Microsoft Excel Version above 2007.
2. Navigate to “Review” tab from Menu bar.
3. In “Review” Tab you will see “Protect Sheet” option. Select that option.
4. New window will appear with password box asking for password. Enter a strong password for better protection and click “OK”.
5. Now another window will appear with a box asking to re-enter password. Re-enter your password and click “OK”. Save the document.
Your file has now entered in “Read-Only” mode. Only user with known password can edit, modify, delete or remove protection from the sheet.
Part 2. Using Excel 2003:
If you are using Microsoft Excel 2003, its password protection method is little different because of its different interface. Just follow the simple steps and protect your file:
1. Open the Excel Document with Microsoft Excel 2003 that you want to protect with password.
2. On the menu bar of the file window, click "Tools" to open the drop-down list then select "Options".
3. A new “Option” window will appear, look for Security Tab and click on it. There you will see two types of password fields. Typing a password in the Password to open text means that you will set a password to protect the Excel document's access permission. Typing a password in the Password to modify text means that you are setting a password to protect the modifying privilege. Anyone who has no password to modify can read-only the document, but he cannot modify the document. Set the password in the fields and click “OK”.
Important: You can see “Advanced” option in front of “Password to open” field. If you click on it new window will appear. Select an encryption type in the list. Then click "OK".
4. If you have set both passwords after clicking “OK” two new windows will appear asking you to re-enter both password first “Password to Open” then “Password to Modify”.
5. Now save the document by clicking "File" in the menu bar and selecting "Save".
Now your document is Password protected. When you again open the protected Excel file it will first ask the “Password to open” then it will redirect you to read-only mode. If you want to edit you have to provide “Password to Modify”.
Bonus Tips: How to Unprotect Excel Sheet
You can unprotect Excel Sheet by following the same steps. But instead of “Protect Sheet” there will be available “Unprotect sheet”. When you will click on that option it will require a password. if you know the password it would be easy to unprotect. But if you lost or forgot your password you don’t have to worry. Use PassFab for Excel software to unprotect sheet It not only recovers the password but it provides the opportunity to remove the password as well. You just have to install and run PassFab Excel Password Recovery. Then import your protected excel file and select any of the 3 options for Password Attack. There are 3 options available:
- Dictionary Attack: If you have a password dictionary already, please import the dictionary file, it will help you sift the right password from the dictionary. Actually, this option guarantees a great rate for success.
- Brute-force with Mask Attack: Enter whatever you still remember in the password. This option will check the customize number, symbols, and characters to find your password.
- Brute-force attack: This option will check all characters one by one to find your password. It’s the default option for Excel spreadsheet password recovery.
After selecting the Password Attack type click start and let the software do rest. A dialogue box will appear with the password of your excel file. Use this password to decrypt your file. Here is the guide to use PassFab Excel Password Recovery:
Open the Excel Password Recovery tool click on “Add” to import the Excel file you want to open.
Now select the Attack type and set parameters accordingly. There are three types of attacks which are Brute-force Attack, Brute-force with Mask and Dictionary.
Click on “Start” to recover the password.
Now you can easily open the file with the recovered password.
You don’t need to be an IT expert for encrypting your Excel file. It’s only a couple of steps procedure. Apart from that now you can protect you excel file without fear of losing the password. If your boss asked you to get an old protected excel file fixed, you don’t need to follow any solutions just use PassFab for Excel software and get your work done easily.
Product-related questions? Speak directly to our Support Team >>