Suppose you've created a workbook like the one shown in Figure 7-6. You might want to monitor the
Figure 7-6: You can work on the summary worksheet while viewing supporting worksheets in the same workbook.
To view both windows on your screen, click View, Arrange All, and then select any of the Arrange options except Cascade. If you select the Cascade option, you'll be able to view only the top worksheet in the stack. If you select the Horizontal option, your screen looks similar to the one shown in Figure 7-7.
Figure 7-7: After clicking the New Window button to open a second window for the same workbook, select an Arrange option to fit both windows on the screen
You might notice that Office Excel 2007 assigned the
Again, if other workbooks are open but you want to view only the windows on the active workbook, select the Windows Of Active Workbook check box in the Arrange Windows dialog box.
You can view any part of the workbook in any window associated with that workbook. In Figure 7-7, Pacific Sales.xlsm :2 originally displayed the summary worksheet when we first created it, because that was the active worksheet when we clicked the New Window button. Then we clicked the Brass tab in the new window, leaving the summary worksheet visible in Pacific Sales.xlsm :1.
When you create multiple windows of the same workbook, anything you do in one window happens in all windows-almost. New entries; formatting changes; inserted or deleted rows,
Figure 7-8: You can change the display characteristics of one window without
Figure 7-9 shows a somewhat exaggerated example of worksheet auditing. In Pacific Sales.xlsm :1, formulas are displayed; the worksheet is zoomed in; and scroll bars, row and column headings, and gridlines are removed-all in an effort to review the formulas in the summary worksheet to make sure they refer to the proper cells. You can also use this technique to audit your worksheets.
Figure 7-9: You can
If you create a view like
:1 in Figure 7-9 and want to be able to re-create it in the future, click the Custom Views button in the Workbook Views group on the View tab to save it. If you want to be able to re-create the entire workspace, including additional windows and their view settings, click the Save Workspace button in the Window
For more information about custom views, see " Using Custom Views " on page 156. For more information about saving workspaces, see " Saving the Entire Workspace " on page 60. For more information about the auditing features in Excel, see " Auditing and Documenting Worksheets " on page 241. For more information about formulas, see Chapter 12 , "Building Formulas."
Inside Out-Close the Default Settings Window Last
When you have two windows open in the same workbook and then close one of them, the "number" of the open window isn't important, but the view settings are. In the example shown in Figure 7-9, if we finish our work and close Pacific Sales.xlsm :2, the modified view settings in Pacific Sales.xlsm :1 become the active view for the workbook. If we then save the workbook, we also save the modified view settings. Make sure you close the windows with view settings you don't want to keep before you close the one with the settings you want to use as the default-don't worry about the window number.