Excel 2k - page break preview over multiple sheets.

[scroce]

If you have a 3-d print range, is it possible to assign a page break preview scheme to all pages simultaneously?

In other words, I have sheet1, sheet2, and sheet3. They all have the same exact layout, but each contains different data. Each of them is also too long to fit on a regular page, so you have to go into page setup and change it to Landscape and Legal size page

I group them all, but excel (2002 version) arbitrarily puts page breaks in wherever it feels like. When I go to view>page break preview (the one with the blue lines) - it won't allow me to adjust the page breaks simulatneously with sheet1, sheet2, and sheet3 grouped together. ARRGH! so this means I have to go in to each separately and adjust the blue lines on each sheet so that it will break the pages where I want. Not a big deal on 3 sheets, but a MAJOR PAIN on 89 sheets.

Anyone know a way around this. I haven't been able to find one. How much more water would there be in the ocean if it weren't for sponges?

 

[Hasit]

Not sure you can set the preview in that way, but Dale Watson has written an excellent FAQ on printing disjointed ranges which may be part of the solution you are looking for. Take a look at: faq68-1161

 

[scroce]

very interesting. Thanks for the tip! How much more water would there be in the ocean if it weren't for sponges?