How to Set Print Area for Multiple Pages in Excel (2 Ways)

If you want to set the print area for multiple pages in Excel, then you are in the right place. In our practical life, we often need to use Excel and need to print them for various purposes. There we also need to print multiple pages. In this article, we’ll discuss how to set the print area for multiple pages in Excel.

Download Practice Workbook

2 Ways to Set Print Area for Multiple Pages in Excel

Excel offers some easy ways to set the print area for multiple pages. To show this we have made a dataset named Dataset to Set Print Area. The dataset is like this.

Let’s see the ways to set the print area for multiple pages.

1. Using Set Print Area from Page Setup View

We can use the Set Print Area option from Page Setup View to set the print area. To execute this, follow the steps below.

• Firstly, select the cells which we want to set as the print area for Page 1. Here, we have selected cells B4:D15 as the print area.
• Secondly, go to Page Layout > select Print Area > choose Set Print Area.

Again, we need to add some cells to the print area of Page 2.

• To do this, thirdly, select the cells. Here, we have selected the cells of G5:H15.
• Fourthly, go to Page Layout > select Print Area > choose to Add to Print Area.

• Eventually, the print areas are selected.
• To check this, go to View > click Page Break Preview.

Consequently, in the Page Break Preview mode, we can see the two print areas as Page 1 and Page 2 like this.

• Additionally, to return back to the original mode, select View > choose Normal.

Eventually, the normal view of the sheet will return back like this.

Read More: How to Set Print Area to One Page in Excel (with Easy Steps)

2. Utilizing Page Break Preview to Set Print Area for Multiple Pages in Excel

Another way to set a print area for multiple pages is the usage of Page Break Preview. We will work on the following dataset to show this method. So do the steps below.

• Firstly, go to View > choose Page Break Preview.

• Eventually, the sheet including page breaks will appear.
• Secondly, move the page break line toward the right or left to make customized pages. Suppose here we want to make Page 1 with column headers Sales Rep, Product ID, Product Category. So, we’ll drag the page break line towards the left side until the Product Category column comes.

• After dragging the page break line, the page break view is like this.
• So, finally, it means we have set two print areas of Page 1 and Page 2.

Read More: How to Use Page Break in Excel (7 Suitable Examples)

Conclusion

We can set print areas for multiple pages effectively if we study this article properly. Please feel free to visit our official Excel learning platform ExcelDemy for further queries.

Related Articles

• Clear Print Area in Excel (2 Easy Ways)
• How to Show Print Area in Excel (4 Easy Methods)
• [Solved:] Print Area Is Grayed Out in Excel (2 Easy Solutions)
• How to Set Print Area with Blue Line in Excel (5 Easy Ways)
• Print Selected Area in Excel (2 Examples)
• How to Change Print Area in Excel (5 Methods)
• Center the Print Area in Excel (4 Ways)
• [Fixed!] Excel Set Print Area Not Working (2 Possible Solutions)