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-

based cells.

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.

1

Page Layout tab

•

CTRL
+
ACCENT

MARK
(`)
to display

the worksheet with

formulas.

Press

•

Click the right

horizontal scroll arrow

until column J appears

(Figure 2 – 71).

Page Setup

Dialog Box

Launcher

formulas rather than values

displayed as entered

Page Setup

group

2

•

Click the Page Setup

Dialog Box Launcher

(Page Layout tab |

Page Setup group) to

display the Page Setup

dialog box.

Figure 2 – 71

3

•

If necessary, click Landscape in the Orientation area to select it.

•

If necessary, click Fit to in the Scaling area to select it.