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
- Select Split from the Window menu
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
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.
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.
- Select the cell where you want to freeze the worksheet
- Select Freeze Panes from the Window menu
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.
The relevant panes are frozen and the worksheet can be navigated as required
To unfreeze panes, Select Unfreeze Panes from the Window menu.