Set Print Area In Excel

Posted on 27-03-2020 , by: admin , in , 0 Comments

Set Print Area

Problem
I need to set print area in Excel.

Question
How I can Set one or more print areas in Excel?
How I can Add cells to an existing print area in Excel?
How I can Clear a print area in Excel?

Solution(step by step)
Set one or more print areas:
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.

set print area in excel

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.

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.

Note:
1. If the cells that you want to add are not adjacent to the existing print area, an additional print area is created.
2. Each print area in a worksheet is printed as a separate page. Only adjacent cells can be added to an existing print area.
3. When you save your workbook, the print area is saved as well.

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.

Note:
If your worksheet contains multiple print areas, clearing a print area removes all the print areas on your worksheet.

share:

Leave a comment