| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Is there a way where I can print subtotals on each pages?
Is there a way where I can print subtotals on each pages when printing long
table on multiple sheets? |
|
#2
|
|||
|
|||
|
George
Not through the user interface. You probably could using VBA. You might also look at the subtotals functionality (DataSubtotals...) If each data set does not spill over one page then using this together with the 'Page break between groups' will give subtotals at the end of each data set/page -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "George Lim" <George wrote in message ... Is there a way where I can print subtotals on each pages when printing long table on multiple sheets? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Print Range Help | Excel Worksheet Functions | |||
| set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
| Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
| Microsoft Excel could not find anything to print | Excel Discussion (Misc queries) | |||
| Non-Breaking Space + Print Issue | Charts and Charting in Excel | |||
Linear Mode
