Define or clear a print area on a worksheet

If you print a specific selection on the worksheet frequently, you can define a print area (print area: One or more ranges of cells that you designate to print when you don't want to print the entire worksheet. If a worksheet includes a print area, only the print area is printed.) that includes just that selection. When you print the worksheet after defining a print area, only the print area will print. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet again.

What do you want to do?


Set a print area

  1. On the worksheet, select the cells that you want to define as the print area.
  2. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

 Note   The print area that you set is saved when you save the workbook.

Top of Page Top of Page

Add cells to an existing print area

  1. On the worksheet, select the cells that you want to add to the existing print area.
  2. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Add to Print Area.

Top of Page Top of Page

Clear a print area

  1. Click anywhere on the worksheet for which you want to clear the print area.
  2. On the Page Layout tab, in the Page Setup group, click Clear Print Area.

Top of Page Top of Page

 
 
Applies to:
Excel 2007