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

To demonstrate our methods, we’ll use the following dataset:

how to set print area in excel for multiple pages


 

Method 1 – Using Set Print Area Option

STEPS:

  • Select the cells which we want to set as the print area for Page 1. Here, cells B4:D15.
  • Click Page Layout > Print Area > Set Print Area.

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

Let’s add some cells to the print area of Page 2.

  • Select the cells to be added, here G5:H15.
  • Click Page Layout > Print Area > Add to Print Area.

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

  • To check the result, click View in the ribbon > Page Break Preview.

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

  • In the Page Break Preview mode, the two print areas for Page 1 and Page 2 look like this:

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

  • To revert to the original mode, select View > Normal.

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

The normal view of the sheet returns.

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


Method 2 – Applying Page Break Preview

To demonstrate this method, we’ll use the following dataset:

using Page Break Preview

STEPS:

  • Click the View tab > Page Break Preview.

using Page Break Preview

  • The sheet including page breaks will display.
  • 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. Drag the page break line towards the left side until the Product Category column.

using Page Break Preview

  • After dragging the page break line, the two print areas for Page 1 and Page 2 are set.

using Page Break Preview


Download Practice Workbook


Related Articles


<< Go Back to Page Setup | Print in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Shajratul Alam Towhid
Shajratul Alam Towhid

Md Shajratul Alam Towhid, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, holds a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a deep passion for research and innovation, he actively engages with Excel. In his capacity, Towhid not only adeptly tackles complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his unwavering commitment to consistently delivering exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo