How to Password protect a particular Column Or Row in Excel?
Step 1:
Select all cells in current worksheet with pressing the Ctrl key and A key together.
Step 2:
Right click, and select the Format Cell item from the context menu.
Step 3:
In the Format Cells dialog box, uncheck the Locked option under Protection tab, and click OK button. See the following screen shot:
Step 4:
Select cells and ranges that you want to lock.
Step 5:
Right click selected ranges, and select the Format Cell item from the context menu.
Step 6:
In the Format Cells dialog box, check the Lock option under Protection tab, and click OK.
Step 7:
Click the Protect Sheet button in the Changes group under Review tab.
Step 8:
In the Protect Sheet dialog box, enter a password in the blank box under Password to unprotect sheet: See the following screen shot:
Step 9:
Confirm Password dialog box pops up, please reenter the password again.
Step 10: Click OK.
Then it locks and protects only selected cells and ranges in current worksheet, while unselect ranges are editable.
