Microsoft Office Tutorials and References
In Depth Information
If you click the New Window command on the View tab to create two or more
windows in which to view the same workbook, you can use different display options in
each window. For example, you can display formulas in one window and see the results
of those formulas (the usual view) in another window.
The Show Formulas check box is particularly helpful when you need to edit a large
worksheet. You can see your formulas without having to activate each cell and view its contents
on the formula bar. You can also use the Show Formulas check box to document your work:
After you select the Show Formulas check box, you can print your worksheet with the
formulas displayed for archiving purposes.
Usually, zeros entered in cells, or the results of formulas that produce zero values,
display on your worksheet. Sometimes, especially for presentation purposes, it is helpful to
eliminate the clutter of excessive zero values on a worksheet. Under the heading Display
Options For This Worksheet in the Advanced category of the Excel Options dialog box,
clearing the Show A Zero In Cells That Have Zero Value check box causes any such cells to
appear as blank cells on the worksheet. The underlying entries are unaffected, of course. If
you edit an entry or if the result of a formula changes so that the cell no longer contains a
zero value, the value immediately becomes visible. If the Show Formulas check box is also
selected, clearing the Show A Zero In Cells That Have Zero Value check box has no effect on
If you hide zero values, be careful when editing your worksheet. What appears to be an
empty cell might actually contain a formula.
Changing the display font
The display font is not only used for all text and numbers you enter in a workbook, but
it also determines the font used in row and column headings. You can select fonts to
be used when creating new workbooks with the Use This Font As The Default Font and
Font Size drop-down lists in the General category in the Excel Options dialog box. The
default display font is Body Font, which uses the font defined as such in the current
theme. The new display font does not become active until you exit and restart Excel.
When you do, the new font is used in all new workbooks you create. You can learn a lot
more about formatting and themes in Chapter 9.