Print Excel Pivot Table on two pages | MyExcelOnline

When you need to print out your Pivot Table, Excel has you covered when it comes to how you want to print it out. There are levels of customization such as being able to set how you want pagination to happen!

 

Download this workbook to follow along with this tutorial on how to print Pivot Table on two pages:

DOWNLOAD EXCEL WORKBOOK


Here is our Pivot Table that we want to print on 2 separate pages. Say for page 1, we want the years 2012 and 2013, then on page 2, we are going to show the year 2014.

Print Excel Pivot Table on two pages | MyExcelOnline

STEP 1: Let us select the entire Pivot Table. Go to PivotTable Analyze > Actions > Select > Entire PivotTable

Print Excel Pivot Table on two pages | MyExcelOnline

STEP 2: Go to Page Layout > Page Setup > Print Area > Set Print Area

Our print area based on our Pivot Table is now set.

Print Excel Pivot Table on two pages | MyExcelOnline

STEP 3: Select the 2014 row then go to Page Layout > Page Setup > Breaks > Insert Page Break

Print Excel Pivot Table on two pages | MyExcelOnline

STEP 4: Now with our page break all set, go to PivotTable Analyze > PivotTable > Options

We will make sure that the row labels are shown on every printed page

Print Excel Pivot Table on two pages | MyExcelOnline

Go to Printing and check Repeat row labels on each printed page. Click OK

Print Excel Pivot Table on two pages | MyExcelOnline

STEP 5: Go to File > Print

You can now see the first page showing the years 2012 and 2013! Click on the next page.

Print Excel Pivot Table on two pages | MyExcelOnline

On the second page, you will see the year 2014 because that is where we placed the page break.

print pivot table on two pages

 

HELPFUL RESOURCE:

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

Microsoft Excel Training

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn