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

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

Guest

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)?
 
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.
 
Back
Top