how do I keep column titles on subsequent pages of a pivot table

Z

Zoo7

When you have a pivot table that is two or more pages long, how do you go
about ensuring that the column titles are on each page? looking forward to
your thoughts

cheers
 
R

Roger Govier

Hi

From the drop down on the PT toolbar, select Options and select Set Print
Titles.

Regards

Roger Govier
 
Top