Microsoft Office Tutorials and References
In Depth Information
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.
Click the View tab.
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.
Click Arrange All.
l The Arrange Windows dialog
Click an option (
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
Excel displays all open windows.
Click a window to activate it.
You can navigate around each
window independent of the
Drag to adjust the zoom.
l Excel resizes the contents of the