| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
About Page Break
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
About Page Break
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. -- Regards, Tom Ogilvy "Polly" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
About Page Break
Double-click on the Branch field button
Click the Layout button Add a check mark to 'Insert page break after each item' Polly wrote: 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! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
About Page Break
Sorry, missed that you had a pivot table.
-- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... 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. -- Regards, Tom Ogilvy "Polly" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
About Page Break
Thank you both of you!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Page Break Adjustments causes a page break each cell | Excel Worksheet Functions | |||
| How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
| change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) | |||
| Hiding the page number in page break preview background. | Excel Discussion (Misc queries) | |||
| adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
![Polly[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
