Microsoft Office Tutorials and References
In Depth Information
Splitting the Worksheet into Windows
Figure 6-3:
The Income
Analysis
spreadsheet
in a split
window
after
scrolling up the
bottom rows
in the lower
pane.
To split a worksheet into two (upper and lower) horizontal panes, you simply
position the cell pointer at the place in the worksheet where you want to split
the worksheet and then click the Split button on the Ribbon’s View tab (or
press Alt+WS).
The key to the panes created with the Split button is the cell in the worksheet
where you position the pointer before selecting this command button:
To split the window into two horizontal panes, position the cell pointer
in column A of the row where you want to split the worksheet
To split the window into two vertical panes, position the cell pointer in
row 1 of the column where you want to split the worksheet
To split the window into four panes — two horizontal and two vertical —
position the cell pointer along the top and left edge of cell.
After you split the worksheet window, Excel displays a split bar (a thin, light
gray bar) along the row or column where the window split occurs. If you
position the mouse or touch pointer anywhere on the split bar, the pointer
changes from a white-cross to a split pointer shape (with black arrowheads
pointing in opposite directions from parallel separated lines).
Search JabSto ::




Custom Search