How to View Different Parts of a Worksheet at the Same Time in MS Excel XP
- From the File menu, select Open option to choose and open an existing file.
- To split the worksheet horizontally into two panes and view the panes at the same time, move the mouse pointer to the horizontal split bar located at the top-right portion of the active worksheet. When the mouse pointer changes to a split pointer (double-edged arrow), hold and then drag to the desired location.
- To split the worksheet vertically, use the vertical split bar located at the bottom-right of the active worksheet.
- Double-click on the split bars to remove the split views.