Splitting and Freezing Panes
You can split the view to see multiple parts of a spreadsheet and freeze some data to keep it visible no mater where you scroll the view.
Split panes
At the top of the vertical scroll bar or at the right end of the horizontal scroll bar, point to the split box.
When the pointer changes to a split pointer, drag the split box down or to the left to the position you want.
Freeze Panes
Freezing panes allows you to select data that remains visible when scrolling in a sheet. This is useful in keeping row and column labels visible as you scroll. To freeze a pane, do one of the following:
1. The top horizontal pane. Select the row below where you want the split to appear.
2. The left vertical pane. Select the column to the right of where you want the split to appear.
3. Both the upper and left panes. Click the cell below and to the right of where you want the split to appear.
4. On the Window menu, click Freeze Panes.
