| 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) | |||
Linear Mode
