Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Page breaks when using subtotals
I have a large spreadsheet, in which I have calculated subtotals, and I need
page breaks for each subtotal. Is there a way other than by manually inserting at each subtotal, to automatically have page breaks at each subtotal. I am using Microsoft Office 2003 |
#2
|
|||
|
|||
If you use the built-in Subtotal feature (Data Subtotals), you can
check the box to add a page break between groups. Pele wrote: I have a large spreadsheet, in which I have calculated subtotals, and I need page breaks for each subtotal. Is there a way other than by manually inserting at each subtotal, to automatically have page breaks at each subtotal. I am using Microsoft Office 2003 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
I have tried that Debra and it is not working. I have my subtotals printing
by each producer. Yet when I go to print the detail and subtotals for each producer print on 1 sheet - not on separate sheets like I would think they would. Please advise. "Debra Dalgleish" wrote: If you use the built-in Subtotal feature (Data Subtotals), you can check the box to add a page break between groups. Pele wrote: I have a large spreadsheet, in which I have calculated subtotals, and I need page breaks for each subtotal. Is there a way other than by manually inserting at each subtotal, to automatically have page breaks at each subtotal. I am using Microsoft Office 2003 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Office Excel97: Removing Page Breaks | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
excel page breaks - urgent help required | Excel Worksheet Functions | |||
How do I keep page breaks for each page in a sheet without the co. | Excel Discussion (Misc queries) | |||
Page breaks don't show on screen and don't print separately. It i. | Excel Discussion (Misc queries) |