Looking for Ideas - Page Breaks

[Johnny]

All,

I have a worksheet that, depending on the users' input, will either
show or hide certain rows. The worksheet has a total number of rows
equal to 403, so it will print on multiple pages. The paper size will
either be letter (here in the US) or A4 (most other countries). No
matter what rows the user shows or hides, the output to the printer
will always be atleast two pages or more.

Certain ranges of rows should be printed on the same page. That is, I
don't want to place a page break inside these ranges. To be specific,
I have 25 groups of 13 rows and one group of 44 rows that I never want
a page break to divide in two.

Problem is: I can't predict which rows the user will be showing at
any given time, but I still want the printing to look good. Is there
a feature, similar to MS Work, where I can designate a range of rows
as "keep together" (this is like the widows and orphans feature in
Word) so that Excel knows never to place a page break inside the range
or is this something I'm going to have to write custom code for?

Thanks for any input/ideas. This is sort of cosmetic, but it will
make a huge difference to the user.

-Johnny

 

[barnabel]

All,

I have a worksheet that, depending on the users' input, will either
show or hide certain rows. The worksheet has a total number of rows
equal to 403, so it will print on multiple pages. The paper size will
either be letter (here in the US) or A4 (most other countries). No
matter what rows the user shows or hides, the output to the printer
will always be atleast two pages or more.

Certain ranges of rows should be printed on the same page. That is, I
don't want to place a page break inside these ranges. To be specific,
I have 25 groups of 13 rows and one group of 44 rows that I never want
a page break to divide in two.

Problem is: I can't predict which rows the user will be showing at
any given time, but I still want the printing to look good. Is there
a feature, similar to MS Work, where I can designate a range of rows
as "keep together" (this is like the widows and orphans feature in
Word) so that Excel knows never to place a page break inside the range
or is this something I'm going to have to write custom code for?

Do the users hide entire groups? Do you know how many rows fit to a page?

I have a similar thing in some reports I just wrote. After getting all the
page setup done, I scan through and find places where a page break MIGHT go
until I find where an automatic page break is set and then set a manual break
at the last place it might have gone.

Peter