Lock only specific cells and ranges in a protected worksheet

1. If the worksheet is protected, do the following:
· On the Review tab, in the Changes group, click Unprotect Sheet.
NOTE: Protected Sheet changes to Unprotect Sheet when a worksheet is protected.
· If prompted, type the password to unprotect the worksheet.
2. Select the entire worksheet by clicking the Select All button.
Select All button
3. On the Home tab, in the Font group, click the Format Cell Font dialog box launcher.

Keyboard shortcut You can also press CTRL+SHIFT+F or CTRL+1.
4. On the Protection tab, clear the Locked check box, and then click OK.
NOTE: This unlocks all of the cells on the worksheet when you protect the worksheet.
5. In the worksheet, select just the cells that you want to lock.
6. On the Home tab, in the Font group, click the Format Cells Font dialog box launcher.
(Keyboard shortcut You can also press CTRL+SHIFT+F or CTRL+1.)
7. On the Protection tab, select the Locked check box, and then click OK.
8. On the Review tab, in the Changes
group, click Protect Sheet.
9. Type a password for the worksheet.
· Changing the size and position of the windows for the workbook when the workbook is opened