Is there a way where I can print subtotals on each pages?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way where I can print subtotals on each pages when printing long
table on multiple sheets?
 
George

Not through the user interface. You probably could using VBA. You might
also look at the subtotals functionality (Data>Subtotals...)

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
(e-mail address removed)
 
Back
Top