Page 105 - Excel 2007 Bible

08_044039 ch04.qxp 11/21/06 10:56 AM Page 62
Part I
Getting Started with Excel
Zooming affects only the active worksheet, so you can use different zoom factors for different
TIP
TIP
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 5), zooming your worksheet to 39 percent
CROSS-REF
CROSS-REF
or less displays the name of the range overlaid on the cells. Viewing named ranges in this man-
ner 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 work-
book, 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 4.6. In this case,
each window shows a different worksheet in the workbook. Notice the text in the windows’ title bars:
climate data.xls:1 and climate data.xls:2. To help you keep track of the windows, Excel
appends a colon and a number to each window.
TIP If the workbook is maximized when you create a new window, you may not even notice that
TIP
Excel has created the new window; but if you look at the Excel title bar, you’ll see that the
workbook title now has :2 appended to the name. Choose View ➪ Window ➪ Arrange and 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.
FIGURE 4.6
Use multiple windows to view different sections of a workbook at the same time.

62