Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Page Breaks from Pivot Tables
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Page Breaks from Pivot Tables
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 Fred wrote: 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 Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove old labels from refreshed pivot tables? | Excel Discussion (Misc queries) | |||
Pivot tables and dynamic columns | Charts and Charting in Excel | |||
Mileage Claim Formula | New Users to Excel | |||
Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
Multiple Pivot Tables with single Page Field | Excel Discussion (Misc queries) |