Microsoft Office Tutorials and References
In Depth Information
Displaying and Printing the Formulas Version of the Worksheet
selected range
prints
Figure 2 – 66
Other Ways
1. Select range, tap or click Print Area button (PAGE LAYOUT tab  Page Setup group), tap or click ‘Set Print Area’, tap or click FILE tab to open
Backstage view, tap or click Print tab, tap or click Print button
Displaying and Printing the Formulas Version
of the Worksheet
Thus far, you have been working with the
values version
of the worksheet, which
shows the results of the formulas you have entered, rather than the actual formulas.
Excel also can display and print the
formulas version
of the worksheet, which shows
the actual formulas you have entered, rather than the resulting values.
The formulas version is useful for debugging a worksheet.
Debugging
is the
process of nding and correcting errors in the worksheet. Viewing and printing the
formulas version instead of the values version makes it easier to see any mistakes in
the formulas.
When you change from the values version to the formulas version, Excel
increases the width of the columns so that the formulas and text do not overow into
adjacent cells on the right. The formulas version of the worksheet, thus, usually is
signicantly wider than the values version. To t the wide printout on one page, you
can use landscape orientation, which already has been selected for the workbook, and
the Fit to option in the Page sheet in the Page Setup dialog box.
To Display the Formulas in the Worksheet
and Fit the Printout on One Page
1
ENTER
FORMULAS

2
ENTER
FUNCTIONS

3
VERIFY
FORMULAS
4
FORMAT
WORKSHEET

5
CHECK
SPELLING

6
PRINT
WORKSHEET
The following steps change the view of the worksheet from the values version to the formulas version of
the worksheet and then print the formulas version on one page.
Why?
Printing the formulas in the worksheet can
help you verify your formulas are correct and the worksheet is making the correct calculations.