Print Excel Pivot Table on two pages

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

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.

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

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

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

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

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

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

STEP 5: Go to File > Print

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

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

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

Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.