Repeat Pivot Table Rows while Printing

%3CLINGO-SUB%20id%3D%22lingo-sub-1250386%22%20slang%3D%22en-US%22%3ERepeat%20Pivot%20Table%20Rows%20while%20Printing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1250386%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20wanting%20to%20repeat%20row%20labels%20of%20my%20pivot%20table%20when%20printing.%20Currently%2C%20I%20have%20built%20a%20pivot%20table%20with%20several%20row%20labels.%20The%20first%20two%20row%20labels%20are%20in%20compact%20layout%2C%20and%20the%20rest%20are%20in%20tabular%20layout.%20I%20would%20like%20the%20first%20two%20labels%20to%20carry%20over%20to%20the%20next%20page%20when%20printing.%20I%20have%20included%20a%20PDF%20of%20my%20pivot%20table%20so%20you%20can%20understand%20what%20I%20want.%20This%20only%20includes%202%20pages%2C%20and%20several%20columns%20have%20been%20whited%20out%20for%20privacy%20concerns.%20You%20will%20see%20my%20first%20two%20labels%20(titled%20%22Under%20Construction%20-%2064%20Projects%22%20and%20%22Emergency%20Roads%20and%20Bridge%20Repair%20(ERBR)%20-%2013%20Projects%22).%26nbsp%3B%20Closer%20to%20the%20bottom%20of%20the%20first%20page%2C%20you%20will%20see%20another%20label%2C%20titled%20(%22State%20Aid%20-%2012%20Projects%22).%20The%20first%20page%20looks%20exactly%20like%20I%20want%20it%20do%2C%20but%20my%20problems%20arise%20on%20the%20second%20page.%20I%20would%20like%20my%20first%20label%20(Under%20Construction)%20to%20be%20present%20on%20the%20second%20page%20as%20well.%20In%20addition%2C%20I%20would%20like%20the%20State%20Aid%20label%20to%20carry%20over%20as%20well.%20This%20would%20save%20me%20a%20lot%20of%20time%20flipping%20back%20and%20forth%20to%20determine%20what%20category%20I%20am%20looking%20at.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1250386%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1250424%22%20slang%3D%22en-US%22%3ERe%3A%20Repeat%20Pivot%20Table%20Rows%20while%20Printing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1250424%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F593393%22%20target%3D%22_blank%22%3E%40jabob756%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20I%20can%20suggest%20you%20just%20adjust%20the%20print%20area%20%26amp%3B%20select%20the%20row..%20that%20will%20repeat%20for%20you.%3C%2FP%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-03-24_22-44-42.png%22%20style%3D%22width%3A%20562px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F179211i39F475569CFF27F4%2Fimage-dimensions%2F562x528%3Fv%3D1.0%22%20width%3D%22562%22%20height%3D%22528%22%20title%3D%222020-03-24_22-44-42.png%22%20alt%3D%222020-03-24_22-44-42.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%3C%2FSPAN%3E.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1799242%22%20slang%3D%22en-US%22%3ERe%3A%20Repeat%20Pivot%20Table%20Rows%20while%20Printing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1799242%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F593393%22%20target%3D%22_blank%22%3E%40jabob756%3C%2FA%3E%26nbsp%3B%20not%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am wanting to repeat row labels of my pivot table when printing. Currently, I have built a pivot table with several row labels. The first two row labels are in compact layout, and the rest are in tabular layout. I would like the first two labels to carry over to the next page when printing. I have included a PDF of my pivot table so you can understand what I want. This only includes 2 pages, and several columns have been whited out for privacy concerns. You will see my first two labels (titled "Under Construction - 64 Projects" and "Emergency Roads and Bridge Repair (ERBR) - 13 Projects").  Closer to the bottom of the first page, you will see another label, titled ("State Aid - 12 Projects"). The first page looks exactly like I want it do, but my problems arise on the second page. I would like my first label (Under Construction) to be present on the second page as well. In addition, I would like the State Aid label to carry over as well. This would save me a lot of time flipping back and forth to determine what category I am looking at. 

2 Replies

Hi @jabob756,

 

Best I can suggest you just adjust the print area & select the row.. that will repeat for you.

 

2020-03-24_22-44-42.png

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.