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 Area→Clear Print Area on the Page Layout tab of the Ribbon.
You also can define and clear the Print Area from the Sheet tab of the Page Setup dialog box. Click the Page Setup dialog box launcher on the Page Layout tab to open this dialog box. Then click the Print Area text box on the Sheet tab and select the cell range or ranges directly in the worksheet. To clear the Print Area from this dialog box, select the cell addresses in the Print Area text box and press the Delete key.