Put Worksheets in Separate Panes

BY STANLEY ZAROWIN

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.

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.

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.

SPONSORED REPORT

Solving the lease accounting challenge

The challenges of the new lease accounting standard have been pervasive to say the least. In this free, independently-written report, you'll learn effective adoption strategies as well as resources for easing the transition to the new standard.

FEATURE

Tackling TCJA changes this tax season

Return preparers must be ready for how the Tax Cuts and Jobs Act has modified many common features of individual and business returns.