How to change print area in excel 2010 how to#
How to change print area in excel 2010 full#

We will click anyplace in the Excel sheet where we want to clear the print area If the new print area is adjacent to the former print area, both print areas are merged and the printing occurs on the same sheet.

This new print area will print on a separate page.

The new print area must be adjacent to the former print area, else, Excel will generate a new print area.

This will adjust the print area to contain the new cells

We can only use the Add Print Area option if we have an existing print area for the worksheet.

We will click Print Area as shown in figure 5 and select Add Print Area.

We will select the range of cells we want to addįigure 5: Clicking Page Layout for Changing Print Area.

We can add cells to a current print area by doing the following:

The print areas are saved when we save the workbook and remains active when reopened.

We can set several print areas for different sheets in the same workbook.

Assuming we set print area in SHEET 1, that print area is only for sheet 1.

To print more than one Excel print area, press the CONTROL KEY and highlight the areas.

We can have many print areas in a single worksheet.

We can confirm by checking the Name managerįigure 3: Click Formulas for Set Print Area Confirmationįigure 4: Name Manager dialog box showing the Print Area Notes When we print this worksheet, only these cells will show.

The selected range of cells is now set as the print area.

We will click Print Area as shown in figure 2 and select Set Print Area.

Select the range of cells that we want to set as the print areaįigure 2: Clicking Page Layout for Setting Print Area.

In setting print area, we will do the following:

How to change print area in excel 2010 full#

It is also possible to change the print area by adding cells to the print area or clearing the entire print area to print the full worksheet. After we have defined the print area, only that area will be printed.

How to change print area in excel 2010 how to#

How to set the print area or how to print a rangeįigure 1: How to Set Print Area What is Print Area ?Ī print area consists of a range of cells that we select to print when we don’t want to print the whole worksheet.

By following the simple steps below, this tutorial will walk all Excel users through the process of: We can set a print area to print only a certain part of our sheet. How to Set Print Area in Excel – Excelchat