How To Lock Worksheet In Excel 2007. On the protection tab, select the locked check box,. When you protect a worksheet, excel locks all of the cells from editing.
Select the cells you want to lock. On the home tab, in the alignment group, click the small arrow to open the format cells popup window. Move the pointer to cells for which the locked box is unchecked on the protection tab of the format cells dialog.