Microsoft Office Tutorials and References
In Depth Information
To Set the Print Area
Table 4–3 Print Options Available Using the Sheet Tab in the Page Setup Dialog Box ( continued )
Print Option
Description
Print titles area
This area is used to instruct Excel to print row titles and column titles on each printed
page of a worksheet. You must specify a range, even if you are designating one col-
umn (e.g., 1:4 means the fi rst four rows).
Gridlines check box
A check mark in this check box instructs Excel to print gridlines.
Black and white check box
A check mark in this check box speeds up printing and saves colored ink if you have
colors in a worksheet and a color printer.
Draft quality check box
A check mark in this check box speeds up printing by ignoring formatting and not
printing most graphics.
Row and column headings
check box
A check mark in this check box instructs Excel to include the column heading letters (A,
B, C, etc.) and row heading numbers (1, 2, 3, etc.) in the printout.
Comments box
Indicates where comments are to be displayed on the printout.
Cell errors as box
Indicates how errors in cells should be displayed on the printout.
Page order area
Determines the order in which multipage worksheets will print.
To Set the Print Area
The following steps print only the Loan Payment Calculator section by setting the print area to the
range B1:E6.
1
Select the range B1:E6 and then
click the Print Area button on the
Ribbon to display the Print Area
menu (Figure 4–49).
Print Area
button
Set Print Area
command
Print Area
menu
range B1:E6
selected
Figure 4–49
 
 
Search JabSto ::




Custom Search