can I automatically insert a page break after subtotals in Excel?

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

Guest

Trying to take a large sheet of data, subtotal and print separate sheet for
each subtotaled group without manually inserting page break before printing.
Using Excel 2002. thanks
 
Hi Teri
when you do your subtotals, check the box for inserting a page break between
groups
 
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

EXCEL 2003 - SUBTOTALS 1
How can I automatically print subtotal on last row of every page? 3
Subtotals for printed sheet? 3
Subtotal by Page in either Excel 2003 or 2007 1
Conditional SUBTOTAL in XL210 Table 7
insertm line and subtotal on separate worksheet 1
Getting Text data using the Data - Subtotal feature 1
Grouping Rows in Excel 2007 2

Back
Top