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

How to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.

VIDEO

Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.

COLUMN

Deflecting clients’ requests for defense and indemnity

Client requests for defense and indemnity by the CPA firm are on the rise. Requests for such clauses are unnecessary and unfair, and, in some cases, are unenforceable.