Microsoft Office Tutorials and References
In Depth Information
• Click the Split button to divide the
window into four panes.
• Use the scroll arrows to show the
four corners of the worksheet at
the same time (Figure 3–77).
What is shown in the four panes?
The four panes in Figure 3–77 are
used to show the following:
(1) range A1:C6 in the
(2) range G1:I6
in the upper-
(3) range A14:C26
in the lower-left
pane; and (4) range G14:I26 in
the lower-right pane. The
vertical split bar is the vertical bar
going up and down the middle of
the window. The horizontal split
bar is the horizontal bar going
across the middle of the window.
If you use the scroll bars below
the window and to the right of
the window to scroll the window,
you will see that the panes split by
the horizontal split bar scroll together
vertically. The panes split by the vertical split bar scroll together horizontally. To resize the
panes, drag either split bar to the desired location in the window.
vertical split bar
for top and
move in vertical
move in vertical
for left and
left panes move
right panes move
1. Drag horizontal split
box and vertical split
box to desired locations
To Remove the Panes from the Window
1 Position the mouse pointer at the intersection of the horizontal and vertical split bars.
2 When the mouse pointer changes to a four-headed arrow, double-click to remove the four
panes from the window.
If you want to split the
window into two panes,
rather than four, drag the
vertical split box to the
far left of the window
or horizontal split box to
the top of the window
(Figure 3–78 on the next
page). You also can drag
the center of the four
panes in any direction
to change the size of
The automatic recalculation feature of Excel is a powerful tool that can be used to analyze
worksheet data. Using Excel to scrutinize the impact of changing values in cells that are
referenced by a formula in another cell is called what-if analysis or sensitivity analysis .
When new data is entered, Excel not only recalculates all formulas in a worksheet, but
also redraws any associated charts.