prevent a cell from breaking and printing on the next page

I am creating a Status Report form. Once the report is filled out the amount
of data in that cell may cause a page break and force the cell onto the next
page leaving the previous page with a big blank space. Is there a way for
the cell, or the data, to automatically split so when the report prints the
data is on each page?

That wouldn't help because that would not change the break in the page.

Thanks . . .


"davesexcel" wrote:

>
> did you try to set the print range?
>
>
> --
> davesexcel
>
>
> ------------------------------------------------------------------------
> davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=539097
>
>