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

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)?

Hi
only possib le using VBA.

--
Regards
Frank Kabel
Frankfurt, Germany
"george_visalia" schrieb im
Newsbeitrag ...
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.

george_visalia wrote:

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)?

--

Dave Peterson