Put Worksheets in Separate Panes
| Q. Sometimes I need to work on two different parts of a spreadsheet at the same time. I know I can split the screen, but how can I view different parts of the worksheet on the screen? |
 A. You may not realize it, but by splitting the screen you’ve achieved half your goal already. As you know, you can divide a spreadsheet window into two or four panes, which is what Microsoft calls them. The panes can split the worksheet horizontally and vertically.
The vertical divider is in the bottom-right corner, to the right of the horizontal scroll bar. A second way to divide the worksheet is to click on Window in the toolbar and then Split . That divides the sheet into four panes. Once the panes are established, you can scroll within each pane independently, as shown above. |
There are two ways to make the division. One way is to use the divider bars. One is situated in the upper-right corner of the window above the vertical scroll bar and by dragging it, you can pull down a vertical divider. If all you want to do is divide the worksheet in half horizontally, double-click on the small bar and presto, it’s done. 
