Microsoft Office Tutorials and References
In Depth Information
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
To Split a Window into Panes
When working with a large worksheet, you can split the window into two or four panes to view different parts
of the worksheet at the same time. Splitting the Excel window into four panes at cell D7 allows you to view all four
corners of the worksheet easily. The following steps split the Excel window into four panes.
• Select cell D7, the intersection of
the four proposed panes.
• If necessary, click the View tab
on the Ribbon and then point to
the Split button on the Ribbon
panes will be
and to the left
of active cell