How do I subtotal pages in Excel?

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

Guest

I want to subtotal a column per page in Excel 2000, however the page may vary
as I add and delete records. Can anyone help me?
 
Shouldn't be a problem as XL will automatically adjust it's total
formula as you add and delete.
I'm assuming you are putting in a sum formula ("=sum( cell1:cell2)").
 
Data/subtotals dialog has a checkbox for page breaks between totals
 
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

Conditional SUBTOTAL in XL210 Table 7
How can I automatically print subtotal on last row of every page? 3
Subtotal by Page in either Excel 2003 or 2007 1
Subtotals for printed sheet? 3
Getting Text data using the Data - Subtotal feature 1
subtotal pages 2
Excel subtotals 1
Subtotals Nightmare in Excel 2003 4

Back
Top