Show All

Hide All

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.

• 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

• How do I make a dynamic print range in excel?
• Print range names and how know if have too many?
• Area prints as A rea, How do I fix this in excell?
• Print Area ranges print on separate pages?