Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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)? |
#2
|
|||
|
|||
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)? |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting Data from Excel | Charts and Charting in Excel | |||
multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
slow page break previews | Excel Discussion (Misc queries) | |||
insert data from one excel file into another | Excel Discussion (Misc queries) |