How can I display totals on the bottom of a printed page in Excel.

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

Guest

I have a spreadsheet that prints on multiple pages. I would like the totals
row to print on the bottom of each page. The totals would be for the whole
column not just waht is on the page.
 
This may not help you, but if you use the 'Sub Total' function
(Data>Subtotal...) then you can insert a page break between each 'group'

Just a thought that may help, other than that you are going to need to do it
manually

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
 

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

how to carry forward a total from one page to another 3
subtotal pages 2
Page subtotals 1
how to print a row on the bottom of every page 1
How to set up Excel to print wrapped columns on a page. 1
Group Totals and Grand Totals on each page 3
Page Subtotals 2
How can I automatically print subtotal on last row of every page? 3

Back
Top