Page Breaks from Pivot Tables

[Fred]

I am creating a pivot table that has as its primary break a department
number, with lots of details properly summarized under it. Each
department with a differnt length report.

Is there a way to automatically enter Page Breaks so that each
department prints on a separate page?
Thanks in advance,

Fred in NY

 

[Debra Dalgleish]

Double-click the Department field button.
In the PivotTable field dialog box, click the Layout button
Add a check mark to 'Insert page break after each item'
Click OK, click OK

To see the headings on each page:
Right-click on a cell in the pivot table
Choose Table Options
Add a check mark to 'Set print titles'
Click OK