Follow the steps below to password protect specific cell ranges within an Excel worksheet.
1. In the Excel windows, click the "Review" tab in the ribbon at the top and select "Allow Edit Ranges"
2. Click "New"
3. Enter a name for the Cell Range, select the range of cells you want to protect, enter a password to use when unlocking the cell range, and click OK
4. Re-enter the password to use when unlocking the cell range
5. Repeat steps 2 - 4 to create another protected cell range
6. Once you are finished creating the protected cell ranges, click "Protect Sheet"
7. If you do not want to create a separate password to protect the entire worksheet in addition to the protected cell ranges, just leave the field under "Password to unprotect sheet" blank and click OK.
If you enter a password in the field under "Password to unprotect sheet," users will be prompted to enter a password when opening the worksheet and also prompted to enter another password when editing a cell within the protected cell range.
When a user tries to edit a cell within the protected cell range, they will be required to enter the password for that particular cell range before they can make any changes to the cell.
Want to try it out? Open the attached file and click on cell 5 under column1. When the prompt appears for a password, enter test1 and click OK. Then, try editing cell 5 under column1.