Sign in

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

´╗┐

Was this information helpful?

How can we improve it?

How can we improve it?

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

Thank you for your feedback!