Excel > Excel 2007 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. Click the View tab on the Ribbon
  4. Click the Split button in the Window group
  5. Split button in the Window group

    The worksheet is split into sections that can be navigated individually without moving the other sections.

    Worksheet with split panes

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

    Adjusting split panes

Click the Split button in the Window group on the Ribbon again 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. Click the View tab on the Ribbon
  2. Click the Freeze Panes button in the Window group
  3. A list appears with three options

  • Freeze Panes: Freezes the worksheet above and to the left of the active cell.
  • Ensure that you select the required cell before clicking this option. Unlike split panes, frozen panes cannot be moved. You need to unfreeze the panes and then freeze again.

  • Freeze Top Row: Freezes the top row, keeping it visible whilst you scroll through the rest of the worksheet.
  • Freeze First Column: Freezes the first column, keeping it visible whilst you scroll through the rest of the worksheet
  • Freeze panes

  1. Select the desired option from the list
  2. The relevant panes are frozen and the worksheet can be navigated as required

To unfreeze panes, click the Freeze Panes button in the Window group and select Unfreeze Panes

Show Me

Follow us on

Facebook  Twitter  You Tube