Microsoft Office Tutorials and References
In Depth Information
Viewing and Printing Worksheet Formulas
5. Below the preview, click the Next Page button . The first page of the print
job contains the contents of the Documentation worksheet in portrait
orientation, and the second page contains the Customer Orders worksheet in landscape
6. Click the Print button. The worksheet prints.
Viewing and Printing Worksheet Formulas
The printout of the Customer Orders worksheet displays only the worksheet values and
none of the formulas. Most of the time, you will be interested in only the fi nal results of
the worksheet, not the formulas used to calculate those results. However, in some cases,
you might want to view the formulas used to develop the workbook. This is particularly
useful when you encounter unexpected results and you want to examine the
underlying formulas, or you want to discuss your formulas with a colleague. You can view the
formulas in a workbook by switching to formula view , a view of the worksheet contents
that displays formulas instead of the resulting values.
You’ll look at the Customer Orders worksheet in formula view now.
To view the formulas in the Customer Orders worksheet:
1. Click the Customer Orders sheet tab, if necessary, and then click the Normal
button on the status bar. The Customer Orders worksheet is active and
displayed in Normal view.
To toggle in and out of
formula view, press the
Ctrl+` keys. The ` grave
accent symbol is usually
located above the Tab key
on your keyboard.
2. Press the Ctrl+` keys. The worksheet changes to formula view.
3. Scroll the worksheet to the right to view the formulas in columns F and H. The
column widths are wider to display the entire formula in each cell. As long as you
don’t resize the column widths while in formula view, they remain unchanged in
other views. See Figure 1-31.
Figure 1-31
Worksheet in formula view
numeric date values
are displayed
formulas are displayed
rather than values
text and number s
remain unchanged
Search JabSto ::

Custom Search