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.
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 Option to Print Multiple Pages in Excel
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 feature.
Eventually, the normal view of the sheet will return back like this.
2. Applying 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.
Download Practice Workbook
We can set print areas for multiple pages effectively if we study this article properly. If you have any questions or confusion, feel free to leave a comment.