Microsoft Office Tutorials and References
In Depth Information
Work with
MULTIPLE WINDOWS
When a worksheet contains a large amount of
data, you cannot see all of it at the same time.
Excel enables you to open additional copies of
the worksheet, each in its own window, so you
can view them simultaneously yet manipulate
them independently. You can view the
worksheets side by side, stacked, tiled, or
cascaded. The zoom settings control how much
of a worksheet appears on your screen.
Did You Know?
If you have a large worksheet and want to view different
parts of the worksheet at the same time, you can split
the worksheet. Click the View tab and then click the
Split button ( ). Excel splits the worksheet into four
parts. To remove a splitter, drag the splitter off the
screen or click the Split button again.
1
1
Click the View tab.
2 3
2
Click New Window.
l Excel creates a new window.
Note: Excel opens a copy of your
worksheet in a new window. The
copy may be directly on top of the
old window so you may not be
able to discern that it is there.
4
5
3
Click Arrange All.
l The Arrange Windows dialog
box appears.
4
Click an option (
changes
to ).
Note: Horizontal places the
windows on top of each other.
Vertical places the windows side
by side. Tiled places the windows
in columns and rows. Cascade
places the windows on top of each
other with the Title bar for each
window displayed.
6
5
Click OK.
Excel displays all open windows.
6
Click a window to activate it.
You can navigate around each
window independent of the
other window.
7
7
Drag to adjust the zoom.
l Excel resizes the contents of the
window.
226
Search JabSto ::




Custom Search