Microsoft Office Tutorials and References
In Depth Information
Viewing a worksheet in multiple windows
You can change the zoom factor of the active worksheet window by using any of three
methods:
Use the Zoom slider located on the right side of the status bar. Drag the slider,
and your screen transforms instantly.
Press Ctrl and use the wheel button on your mouse to zoom in or out.
Choose View Zoom Zoom, which displays a dialog box with some zoom
options.
Select a range of cells, and choose View Zoom Zoom to Selection. The
selected range will be enlarged so it fi fills the entire window.
Zooming affects only the active worksheet window, so you can use different zoom factors for different worksheets.
Also, if you have a worksheet displayed in two different windows, you can set a different zoom factor for each of the
windows.
If your worksheet uses named ranges as described later in this chapter, zooming your worksheet to 39% or less
displays the name of the range overlaid on the cells. Viewing named ranges in this manner is useful for getting an
overview of how a worksheet is laid out.
Viewing a worksheet in multiple windows
Sometimes, you may want to view two different parts of a worksheet simultaneously —
perhaps to make referencing a distant cell in a formula easier. Or you may want to
examine more than one sheet in the same workbook simultaneously. You can accomplish either
of these actions by opening a new view to the workbook, using one or more additional
windows.
To create and display a new view of the active workbook, choose View
Window
New
Window.
Excel displays a new window for the active workbook, similar to the one shown in
Figure 14.6. In this case, each window shows a different worksheet in the workbook. Notice
the text in the windows’ title bars: climate data.xlsx:1 and climate data.xlsx:2 .
To help you keep track of the windows, Excel appends a colon and a number to each
window.
Search JabSto ::




Custom Search