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

Get FREE Advanced Excel Exercises with Solutions!

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.

how to set print area in excel for multiple pages

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.

how to set print area in excel for multiple pages, using 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.

how to set print area in excel for multiple pages, using Set Print Area

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

how to set print area in excel for multiple pages, using Set Print Area

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

how to set print area in excel for multiple pages, using Set Print Area

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

how to set print area in excel for multiple pages, using Set Print Area

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

how to set print area in excel for multiple pages, using Set Print Area

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.

using Page Break Preview

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

using 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.

using Page Break Preview

  • 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.

using Page Break Preview

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

Shajratul Alam Towhid

Shajratul Alam Towhid

Hello, myself Shajratul Alam Towhid. Basically, I am a Naval Architect who wants to expand knowledge in the field of Microsoft Excel. I wish all of my articles will be beneficial for the readers.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo