Adjusting Page Breaks in Excel 2007
Printing Gridlines and Row and Column Headings in Excel 2007
Adding a Standard Header or Footer in Excel 2007

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:

  1. 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.

  2. 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.
    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.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
How to Repeat Row and Column Headings When You Print in Excel 2007
How to Use Excel 2007’s Scale to Fit Printing Options
Previewing Pages in Excel 2007 with Print Preview
Selecting a Printer in Excel 2007
How to Change the Print Margins in Excel 2007
Advertisement

Inside Dummies.com