How To Lock Worksheet In Excel 2007

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.

Lock or Unlock Worksheet Cells Cell Edit « Editing « Microsoft Office
Lock or Unlock Worksheet Cells Cell Edit « Editing « Microsoft Office from www.java2s.com

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.