Pinterest Pixel

Print Excel Pivot Table on two pages

When you need to print out your Pivot Table, Excel has you covered when it comes to... read more

Download Excel Workbook
Bryan
Posted on
Print Excel Pivot Table on two pages

Overview

Print Excel Pivot Table on two pages

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

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

Print Excel Pivot Table on two pages

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

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

Print Excel Pivot Table on two pages

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

See also  Group Periods In Microsoft Excel Pivot Tables

Print Excel Pivot Table on two pages

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

Print Excel Pivot Table on two pages

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

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

Print Excel Pivot Table on two pages

 

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

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!