Excel > Excel 2003 Foundation > Managing Worksheets

Splitting and Freezing Panes

Splitting or freezing panes allow you to hold sections of a worksheet in place so they are visible at all times whilst scrolling through the worksheet. This is especially useful for large worksheets because you can hold the column and row headings in place whilst you scroll through your data.

Splitting panes on a worksheet

Splitting panes allows you to see multiple areas of a worksheet at once. So you can make changes to the data in cell D500 whilst viewing the data in cell D5.

  1. Select the cell where you want to split the worksheet
  2. The worksheet will be split above and to the left of the active cell creating four panes.

  3. Select Split from the Window menu
  4. The worksheet is split into sections that can be navigated individually without moving the other sections

    Split panes on a worksheet

    Click and drag the panes to adjust the location of the split

    Moving a split pane

Select Remove Split from the Window menu to remove the split.

Worksheets can also be split using the split buttons at the top and to the right of the worksheets scroll bars. To split the worksheet, drag the relevant split button onto the area of the worksheet where you wish to create the split.

Split buttons

Freezing panes on a worksheet

Freezing panes is similar to splitting panes except that the panes are immobilised. Freeze panes is used to hold headers in place so that they can always been seen when scrolling through the worksheet.

  1. Select the cell where you want to freeze the worksheet
  2. The worksheet above and to the left of the active cell will be frozen. For example, if you want to freeze only the top row, select cell A2.

    Freeze Panes from the Window menu

  3. Select Freeze Panes from the Window menu
  4. The relevant panes are frozen and the worksheet can be navigated as required

To unfreeze panes, Select Unfreeze Panes from the Window menu.

Follow us on

Facebook  Twitter  You Tube