Part I: Getting Started with Excel
■ (^) Choose View ➪ Zoom ➪ Zoom, which displays a dialog box with some zoom options.
Also in the Zoom Ribbon group is a 100% button to return to 100% zoom quickly and a
Zoom to Selection button to change the zoom so that whatever cells you have selected take
up the whole window (but still limited to the 10–400% zoom range).
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 (see Chapter 4, “Working with Excel Ranges and Tables”), zoom-
ing 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—per-
haps 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
3.5. 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 hyphen and a number to each
w indow.
If the workbook is maximized when you create a new window, you may not even notice that Excel created the new
window. If you look at the Excel title bar, though, you’ll see that the workbook title now has - 2 appended to the
name. Choose View ➪ Window ➪ Arrange All and then choose one of the Arrange options in the Arrange Windows
dialog box to display the open windows. If you select the Windows of Active Workbook check box, only the windows of
the active workbook are arranged.
A single workbook can have as many views (that is, separate windows) as you want. Each
window is independent. In other words, scrolling to a new location in one window doesn’t
cause scrolling in the other window(s). However, if you make changes to the worksheet
shown in a particular window, those changes are also made in all views of that worksheet.