Earl
The row heights will not be the same. What would the macro do? How would I
tell it to keep the rows together?

I can't do it the seond way you suggest because it must be as automatic as
possible. There will be many different end users. I've put in a manual
break, which will work if no one gets too verbose. I just thought if there
was a (reasonably straightforward) way to automate it, that would be better.

Thanks for your reply.
Rita

"Earl Kiosterud" wrote:

Rita,

This can be done with a macro if all the row heights are the same, if you're
willing to get into that. I suppose it could be done where the row heights
are not the same too.

It might not be worth the macro effort, unless the sheet is very large. If
you do a print preview, it will put the page breaks on the sheet with dotted
lines. Or you can use View - Page Break Preview. Now that the page breaks
are visible, you can manually either put in and remove page breaks as needed
to keep the groups together, or insert rows, depending on how you want to
handle it.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Rita" wrote in message
...
I am creating a form in Excel. The rows may expand as the user enters
data.
Is there any way to keep each "section" in the form together, so that a
ssection does not split at a page break but jumps in its entirety to the
next
page? I know I can do this in Word, but this form has lots of serious
calculations so it must be in Excel.