Freezing and Splitting Rows and Columns in Excel 2007-2013

Freezing and Splitting Rows and Columns in Excel 2007-2013

 

Freezing versus splitting rows and columns

When you freeze panes, Microsoft Excel keeps specific rows or columns visible when you scroll in the worksheet. For example, if the first row in your spreadsheet contains labels, you might freeze that row to make sure that the column labels remain visible as you scroll down in your spreadsheet.


Worksheet window with row 1 frozen

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

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

Worksheet with split panes

This worksheet has been split into four areas. Notice that each area contains a separate view of the same data.

Think of the worksheet areas as multiple views of your worksheet. If you make a change in one worksheet area, those changes will automatically be reflected in the other worksheet area(s). Splitting panes is useful when you want to see different parts of a large spreadsheet at the same time.

 

Freeze panes to lock specific rows or columns

Before you choose to freeze panes in a worksheet, it’s important to consider the following:

  • 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.

You can choose to freeze just the top row of your worksheet, just the left column of your worksheet, or multiple rows and columns simultaneously. For example, if you freeze row 1, and then decide to freeze column A, row 1 will no longer be frozen. If you want to freeze both rows and columns at the same time, you must choose to freeze them at the same time.

  1. On the worksheet, do one of the following:
  • To lock rows, select the row below the row or rows that you want to keep visible when you scroll.
  • To lock columns, select the column to the right of the column or columns that you want to keep visible when you scroll.
  • To lock both rows and columns, click the cell below and to the right of the rows and columns that you want to keep visible when you scroll.
  1. On the View tab, in the Window group, click the arrow below Freeze Panes.

Windows group on the View tab

  1. 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.

Unfreeze panes

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

Windows group on the View tab

  1. Click Unfreeze Panes.

 

Split panes to lock rows or columns in separate worksheet areas

 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 selected cell will be frozen and the split bar will be removed.

  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

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

Unsplit panes

  • To restore a window that has been split into two scrollable areas, double-click any part of the split bar that divides the panes.
  • To remove all split panes at once, in the Window group, click Split.

Windows group on the View tab