About Page Break

P

Polly

Dear all,

I have a pivot table where format are displayed as
follows:

Branch A Item 1 $100
Item 2 $200
Branch B Item 2 $200
Branch C Item 3 $300

Since there are so many items for each branch, several
pages are needed for printing. We hope a new branch use a
new page to print. So, is there any method to do? Use VBA
is also OK. Thanks!

Polly
 
T

Tom Ogilvy

you might look at the Data=>Subtotals command in the menus

this would compute a subtotal for each branch (if that is what you grouped
on), but that might be good as well.
 
D

Debra Dalgleish

Double-click on the Branch field button
Click the Layout button
Add a check mark to 'Insert page break after each item'
 
Top