Microsoft Office Tutorials and References
In Depth Information
Displaying and Printing the Formulas Version of the Worksheet
Displaying and Printing the Formulas Version
of the Worksheet
Values versus Formulas
When completing class
assignments, do not enter
numbers in cells that
require formulas. Most
instructors will check both
the values version and
formulas version of your
worksheets. The formulas
version verii es that you
entered formulas, rather
than numbers, in formula-
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 i 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 overl ow into adjacent cells
on the right. The formulas version of the worksheet, thus, usually is signii cantly wider
than the values version. To i t the wide printout on one page, you can use landscape
orientation, which has already 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
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.
Page Layout tab
CTRL + ACCENT
MARK (`) to display
the worksheet with
Click the right
horizontal scroll arrow
until column J appears
(Figure 2 – 71).
formulas rather than values
displayed as entered
Click the Page Setup
Dialog Box Launcher
(Page Layout tab |
Page Setup group) to
display the Page Setup
Figure 2 – 71
If necessary, click Landscape in the Orientation area to select it.
If necessary, click Fit to in the Scaling area to select it.