How to Protect Excel Sheets

/ Posted by Shirley Howard to Excel / Follow @Shirley Howard

Password protection is the best protection now-a-days. People protect their important excel sheets using password. These protections are used so that any unauthorized person could not temper the data in excel sheet. Some time you don't want your user to modify the data in 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 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 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.
  • review tab
  • 3. In “Review” Tab you will see “Protect Sheet” option. Select that option.
  • protect sheet
  • 4. New window will appear with password box asking for password. Enter a strong password for better protection and click “OK”.
  • enter password
  • 5. Now another window will appear with a box asking to re-enter password. Re-enter your password and click “OK”. Save the document.
  • reenter password

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".
  • options in tools
  • 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 the password to modify can read-only the document, but he cannot modify the document. Set the password in the fields and click “OK”.
  • options window

    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".

    advanced encryption
  • 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”.
  • confirm password
  • 5. Now save the document by clicking "File" in the menu bar and selecting "Save".
  • 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 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 Excel Password Recovery 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 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:

Free Try PassFab Excel Password Recovery Now:
Free Download For Win 10/8.1/8/7/XP
Secure Download
  • Open the Excel Password Recovery tool click on “Add” to import the Excel file you want to open.
  • add excel
  • 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.
  • dictionary  settings
  • Click on “Start” to recover the password.
  • start  recovering
  • Now you can easily open the file with the recovered password.
  • password found

You don’t need to be 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 password. If your boss asked you get an old protected excel file fixed, you don’t need to follow any solutions just use PassFab Excel Password Recovery software and get your work done easily. 

Free Try PassFab Excel Password Recovery Now:
Free Download For Win 10/8.1/8/7/XP
Secure Download
Comment

Product-related questions? Speak directly to our Support Team >>