How to View Different Parts of a Worksheet at the Same Time in MS Excel XP

Filed under: Excel, How To 
  1. From the File menu, select Open option to choose and open an existing file.
  2. 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.

  3. To split the worksheet vertically, use the vertical split bar located at the bottom-right of the active worksheet.
  4. Double-click on the split bars to remove the split views.


Leave a Reply

You must be logged in to post a comment.