Microsoft Excel 2007 with Example
3.8 Worksheets: Split
Split your worksheet to view multiple distant parts of your worksheet at once. To split your worksheet (window) into a upper and lower part (pane), execute the following steps.
1. Click the split box above the vertical scroll bar.
2. Drag it down to split your window.
3. Notice the two vertical scroll bars. For example, use the lower vertical scroll bar to move to row 49. As you can see, the first 6 rows remain visible.
4. To remove the split, double click the horizontal split bar that divides the panes (or drag it up).
Note: in a similar way, you can use the split box to the right of the horizontal scroll bar to split your window into a left and right pane. You can even split your window into four panes. Any changes you make to one pane are immediately reflected in the other ones.