Set a specific print area in Excel

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.

    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.

  2. Click the Page Layout tab, click Print Area, and then click Set Print Area.

    Set Print Area

  3. To see the print area that you've select, click the View tab, and then click Page Break Preview in the Workbook Views group.

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

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 the Page Layout tab, click Print Area, and then click Add to Print Area.

    Add to Print Area

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!

×