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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Microsoft Access - Subtotals for each page 0
Printing subtotals on each page 9
Average of Subtotals in Pivot Table 0
How can I automatically print subtotal on last row of every page? 3
Subtotals for printed sheet? 3
I need ONLY subtotals copied to a second sheet 4
Excel - Problem w/ printing more than one worksheet with same sett 0
Conditional SUBTOTAL in XL210 Table 7

Back
Top