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?