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

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

News quiz: Taking an economic snapshot and looking to the future

Recent news included IRS actions that affect individuals and partnerships and a possibly influential move by a Big Four accounting firm.Take this short quiz to see how much you know about the news.