Is there a way to get an auto page break as data changes in Excel.

G

george_visalia

I list my students by grade and by teacher. Is there a way to force a page
break automatically as a specific piece of data changes (ie; teacher name,
grade, room)?
 
D

Dave Peterson

If your teacher names are in column A (say) and sorted, you can select your
range and do:

Data|subtotals
There's an option to put a page break between groups on that dialog.
 
Top