Archive for February 16th, 2015

To keep an area of a worksheet visible while you scroll to another area of the worksheet, you can lock specific rows or columns in one area by freezing or splitting panes.

When you freeze panes, you keep specific rows or columns visible when you scroll in the worksheet. For example, you might want to keep row and column labels visible as you scroll.

Worksheet window with row 1 frozen

A solid line indicates that row 1 is frozen to keep column labels in place when you scroll.

When you split panes, you create separate worksheet areas that you can scroll within, while rows or columns in the non-scrolled area remain visible.

  1. On the View tab, in the Window group, click the arrow below Freeze Panes.

    The Window group on the View tab

  2. Do one of the following:
    • To lock one row only, click Freeze Top Row.
    • To lock one column only, click Freeze First Column.
    • To lock more than one row or column, or to lock both rows and columns at the same time, click Freeze Panes.

NOTE

  • When you freeze the top row, first column, or panes, the Freeze Panes option changes to Unfreeze Panes so that you can unlock any frozen rows or columns.
  • You can freeze rows at the top and columns on the left side of the worksheet only. You cannot freeze rows and columns in the middle of the worksheet.
  • The Freeze Panes command is not available when you are in cell editing mode or when a worksheet is protected. To cancel cell editing mode, press ENTER or ESC. For information about how to remove protection from a worksheet, see Protect worksheet or workbook elements.

Split panes to lock rows or columns in separate worksheet areas

  1. To split panes, point to the split box at the top of the vertical scroll bar or at the right end of the horizontal scroll bar.

    split box

  2. When the pointer changes to a split pointer split bar adjustment pointer or resize pointer (double-headed arrow), drag the split box down or to the left to the position that you want.
  3. To remove the split, double-click any part of the split bar that divides the panes.

NOTE   You cannot split panes and freeze panes at the same time. When you freeze panes within a split pane, all rows above and columns to the left of the selection will be frozen and the split bar will be removed.