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

Add cells to an existing print area

Clear a print area

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

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

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

Applies To: Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language