See all How-To Articles

How to Set the Print Area in Excel & Google Sheets

In this tutorial, you will learn how to set print areas in Excel and Google Sheets.

 

set print area 3

 

Print Area on Selected Range

  1. To set the print area a range of data in Excel, first select the range you want to set as print area. Then in the Ribbon, go to Page Layout > Print Area > Set Print Area.

 

set print area 1

 

  1. In the Ribbon go to View > Page Break Preview.

 

set print area 2

 

As a result, you can see the print area that you selected.

 

set print area 3

 

Set Non-Adjacent Ranges as Print Area

  1. To set non-adjacent ranges, click on the first cell you want to choose. Then press the CTRL key on the keyboard and individually select the rest of the cells you want to add. Now that you’ve selected your non-adjacent range, you can proceed to set that as a print area.
  2. To do that, in the Ribbon, go to Page Layout > Print Area > Set Print Area.

 

set print area 5

 

As a result, you have three print areas, and each will print as a separate page.

 

set print area 6

 

Set Print Area for Multiple Ranges

  1. To set multiple ranges, start by selecting the first range you want to set as print area. Then in the Ribbon, go to Page Layout > Print Area > Set Print Area.

 

set print area 16

 

  1. To add another range to the print area, select another range of data, and then in the Ribbon, go to Page Layout > Print Area > Add to Print Area.

 

set print area 18

 

As a result, you simultaneously have two ranges of data in the print area. Each will print on a separate page.

 

set print area 17

 

Extend the Print Area

To extend an existing print area, select the cells you want to add, and in the Ribbon, go to Page Layout > Print Area > Add to Print Area.

 

set print area 8

 

If you are adding adjacent cells, you will just enlarge the existing print area; but if you are adding non-adjacent cells, you will create a new print area. In the second case, each print area in that worksheet will print as a separate page. In this example, you end up with two different print areas.

 

set print area 9

 

Clear a Print Area

To clear a print area, click anywhere on a worksheet where that print area is, and in the Ribbon go to Page Layout > Print Area > Clear Print Area.

 

set print area 7

 

This deletes the print area. If your worksheet contains multiple print areas, clearing a print area removes all the print areas on your worksheet. Pagination returns to default.

Set Print Area in Google Sheets

 

set print area 14

 

  1. As a first step, select the range of data you want to print, after that in the menu go to File > Print (or use the shortcut CTRL + P).

 

set print area 19

 

  1. The Print settings window will appear. Under the Print option, choose Selected cells.

 

set print area 12

 

As a result, only the cells you selected will print.

 

set print area 13