Grouping Cells + Printing

[Alphacsulb]

I posted this on mrexcel but have not received any responce so Im hoping I might be able to get a lead here.

http://www.mrexcel.com/forum/showthread.php?t=319642

I have a small problem and I am hoping you know have an easy answer for this.

Is there a macro or grouping/merging tool I can use so that when I print a document, rows that I can define are kept together in the page.

I know of manually inserting a page break but I figured that maybe you knew of an easier way so that it did it automatically.

Here is a picture of what I am talking about.

http://i5.photobucket.com/albums/y199/alphacsulb/Group.jpg

And then I print:

http://i5.photobucket.com/albums/y199/alphacsulb/PrintPreview-1.jpg


Any leads would be appreciated.
:dunno

[Simon Lloyd]

Alphacsulb it would be better if you could upload those sheets as part of a workbook, it doesn't need to be the whole 35 sheets of your workbook just the relevant ones, don't forget to remove personal or sensitive data.

[Alphacsulb]

Here is the file.

If you do a print preview you will see that the row 62 is printing on page 2 and row 63 on page three.

Since 62 and 63 belong together I want them on the same page.

Any suggestions?