Related Tutorials
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.
- Select the cell where you want to split the worksheet
- Click the View tab on the Ribbon
- Click the Split button in the Window group
The worksheet will be split above and to the left of the active cell creating four panes.
The worksheet is split into sections that can be navigated individually without moving the other sections.
Click and drag the panes to adjust the location of the split.
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.
 |
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.
- Click the View tab on the Ribbon
- Click the Freeze Panes button in the Window group
A list appears with three options
- Freeze Panes: Freezes the worksheet above and to the left of the active cell.
- 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
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.
- Select the desired option from the list
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
