Set a specific print area

If you frequently print a specific section of your worksheet, you can set a print area for it. That way, when you print your worksheet, only that section will print.

  1. Select the cells you want to print.

Tip:  To set multiple print areas, hold down the Ctrl key and click the areas you want to print. Each print area prints on its own page.

  1. Click Page Layout > Print Area > Set Print Area.

Set Print Area

  1. To see all the print areas to make sure they’re the ones you want, click View > Page Break Preview.

    When you save your workbook, the print area is saved too.

    If you want to print the entire worksheet, instead of specific print areas, see Clear a print area.

Add cells to a print area

You can enlarge the print area by adding adjacent cells. If you add cells that aren’t adjacent to the print area, Excel creates a new print area for those cells.

  1. On the worksheet, select the cells that you want to add to the print area.

  2. Click Page Layout > Print Area > Add to Print Area.

Add to Print Area

For more information on printing in Excel, see Print a worksheet or workbook.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!