Pivot table column names on mulitple pages

yellowcabguy

Active Member
Joined
Dec 28, 2005
Messages
440
I have created a pivot table that is a series of columns that fills two pages. Is there a way to have the column names appear at the top of the second page? As it is now they are not there and it is tough to follow the data.

Thanks
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Dufus

Board Regular
Joined
Aug 19, 2006
Messages
176
yellowcabguy,

Have you tried [File][Page Setup...] from the Excel menu to set the rows to repeat at top from the "Sheet" tab?

Dufus
 

Watch MrExcel Video

Forum statistics

Threads
1,108,491
Messages
5,523,255
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top