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

T

Teri

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
 
M

mzehr

Hi Teri
when you do your subtotals, check the box for inserting a page break between
groups
 
Top