Microsoft Office Tutorials and References
In Depth Information
Useful inconsistencies of new windows
change the settings in the two Display Options sections: Display Options For This Workbook
and Display Options For This Worksheet. You can apply these options differently to
windows of the same workbook. Just select the name of the window you want to change in the
drop-down list, as shown in Figure 7-7.
Figure 7-7 You can change the display characteristics of one window without affecting the other.
Figure 7-8 shows a somewhat exaggerated example of worksheet auditing. Formulas are
displayed in NorthwindSales.xlsx:1; the worksheet is zoomed in, the ribbon is collapsed; and
the formula bar, 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 use this technique to audit your worksheets.
If you create a view like NorthwindSales.xlsx:1 in Figure 7-8 and want to be able to
recreate 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
group on the View tab.