Excel 2013, Lock and Protect Selected Cells

Excel 2013, Lock and Protect Selected Cells

Web

Step 1: Select all cells in current worksheet with pressing the Ctrl + 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.