Microsoft Office Tutorials and References
In Depth Information
Displaying and Printing the Formulas Version of the Worksheet
2
Click the OK button
to print the selected
range of the work-
sheet on the printer
(Figure 2–73).
header prints
selected
range
prints
Click the Normal
View button on the
status bar.
Click cell A18 to
deselect the range
A3:F13.
What are the
options in the Print
what area?
The Print what area
of the Print dialog
box includes four
option buttons
(Figure 2–72). As
shown in the previous
steps, the Selection
option button instructs
Excel to print the
selected range. The
Active sheet(s) option
button instructs Excel to print the active worksheet (the worksheet currently on the screen) or the selected worksheets.
Finally, the Entire workbook option button instructs Excel to print all of the worksheets in the workbook.
Figure 2–73
Other Ways
1. Select range, click Page
Layout tab on Ribbon,
click Print Area button,
click Set Print Area, click
Quick Print button on
Quick Access Toolbar,
click Print Area button,
click Clear Print Area
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. You can toggle between the
values version and formulas version by holding down the CTRL key while pressing the
ACCENT MARK ( ` ) key, which is located to the left of the number 1 key on the keyboard.
The formulas version is useful for debugging a worksheet. Debugging is the process
of fi 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 the formulas and text do not overfl ow into adjacent cells on the
right. The formulas version of the worksheet thus usually is signifi cantly wider than the
values version. To fi 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.
Values versus
Formulas
When completing class
assignments, do not
enter numbers in cells
that require formulas.
Most instructors require
their students to hand in
both the values version
and formulas version
of the worksheet.
The formulas version
verifi es that you entered
formulas, rather than
numbers, in formula-
based cells.
 
 
Search JabSto ::




Custom Search