Making Excel move page breaks automatically?

DaCoOlNeSs

[H]ard|Gawd
Joined
Jun 8, 2004
Messages
1,472
Hey guys and gals,

I'm looking to have my excel sheet automatically move the page breaks around depending on how the data works out. Currently I have a sheet that when a product is selected, it is added to a cover sheet. Then as more products are added, the cover sheet will expand as products are shown and if a product is removed, the cover sheet will shrink so that it isn't always two pages or more long.

The problem I have is that after a certain point, Excel will then cut off at whatever row it can fit on one page, and continue on the next. I'd like to have it so that if it cannot fit whole groups onto the page, it moves the whole section to the next page on print. Here is an excel document to show what I am hoping to do, and if you know the fix please let me know!

http://www.2shared.com/file/ooyxP-cQ/Test_Data.html

Thanks!
 
Top