Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
george_visalia
 
Posts: n/a
Default 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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 06:15 PM
Charting Data from Excel DavidM Charts and Charting in Excel 4 December 30th 04 03:31 PM
multiple or changing colours in a data table on an excel chart fo. Kerri Buxton Charts and Charting in Excel 2 December 23rd 04 08:39 PM
slow page break previews chriscrisco Excel Discussion (Misc queries) 1 December 13th 04 09:06 PM
insert data from one excel file into another Leonard Excel Discussion (Misc queries) 1 December 2nd 04 01:35 PM


All times are GMT +1. The time now is 09:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"