Telling Excel 2007 What You Want to Print Excel 2007 includes a
special printing feature called the print area. You can define
any cell selection on a worksheet as the print area. After you
define the print area, Excel then prints this cell selection any
time you print the worksheet using the Print dialog box or the
Quick Print command on the Office button’s Print menu. Follow
these steps to set a print area in an Excel 2007 worksheet:
Select the range of cells you want to print. You can select
noncontiguous areas of the worksheet by holding down the Ctrl
key as you select the cell ranges. Choose Print Area→Set Print
Area on the Page Layout tab of the Ribbon. Once you define a
print area, its cell range is the only one you can print
(regardless of what other Print What options you select in the
Print dialog box, unless you select the Ignore Print Areas check
box) until you clear the print area.Use the Print Area command
to set or clear a print area. To clear a print area that you set
previously, choose Print