Microsoft Office Tutorials and References
In Depth Information
Setting the Print Area
But Excel lets you have it both ways by letting you designate and save a print area so
you can go on do to work somewhere else before printing.
To see how the Print Area option works,
select the student grades and click the
Page Layout contextual tab, and then click
Print Area Set Print Area in the Page Setup
button group (see Figure 10–19).
Figure 10–19. Setting the print area
You’ll see a dotted-line border surrounding
the area you’ve chosen to print, which will
remain in place even if you click
somewhere else on the worksheet (see
Figure 10–20. The print area is designated by the
Now whenever you’re ready to print, just return to the Backstage and click that large
Print button. Just make sure you don’t select Print Selection at the point of actual printing
though, because if you do any range you happen to have currently selected will be
printed instead of the print area you designated Click Print Active Sheets or Print Entire
Workbook instead. If you save the document, the print area will be saved, too. To clear
the print area, click the Page Layout contextual tab, and then click Print Area Clear Print
Area in the Page Setup button group.