Page 4 of 20PREVNEXT

Audio course: So that's how! Working with really big worksheets

The Window menu, showing the Split command, and the Split box between row 17 and row 1886

Callout 1 Split command.
Callout 2 Split bar.

You can split a worksheet into two or four different panes to get different views of the data in your worksheet at the same time. Perhaps you'd do this to look at different views of monthly or quarterly data. Or you might do this to make it easy to paste data between different areas of a large worksheet.

You split panes by making a selection in the worksheet, and then clicking Split on the Window menu.

You can split panes into:

  • Two panes above and below each other    Select the row below where you want the split to appear.
  • Two panes side by side    Select the column to the right of where you want the split to appear.
  • Four panes    Click the cell below and to the right of where you want the split to appear.

In the practice session you can try this out for yourself, and you'll learn a few ways to split panes other than by using the Split command on the Window menu.

To remove the split, click Remove Split on the Window menu. Or double-click the split bar to remove the split.

Note    If a worksheet already has frozen panes and you split panes, you will simultaneously unfreeze panes and split panes. The same is true if the worksheet has split panes and you freeze panes. You will simultaneously unsplit the worksheet and freeze panes. In other words, you can freeze or split panes, but not do both at the same time.

Page 4 of 20PREVNEXT