Microsoft Office Tutorials and References
In Depth Information
Displaying and Printing the Formulas Version of the Worksheet
Figure 2 – 66
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
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.