Microsoft Office Tutorials and References
In Depth Information
Useful inconsistencies of new windows
Figure 7-8 You can radically change view options in one window while maintaining a regular
view of the same worksheet in another window.
For more information about custom views, see “Using custom views” in Chapter 6, “How to
work a worksheet.” For more information about the auditing features in Excel, see “Auditing
and documenting worksheets” in Chapter 8, “Worksheet editing techniques.” 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-8, if you finish your work and close NorthwindSales.xlsx:2,
the modified view settings in NorthwindSales.xlsx:1 become the active view for the
workbook. If you then save the workbook, you also save the modified view settings.
Be 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.
Search JabSto ::

Custom Search