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.

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.


Keeping you informed and prepared amid the coronavirus crisis

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.


Building process maps: Template and instructions

Documenting your financial close process and finding opportunities for automation are more important than ever. Our customizable slide deck has instructions, a risk assessment questionnaire, and bonus checklists that will help you map out your process.