prevent a cell from breaking and printing on the next page

[Guest]

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?

 

[davesexcel]

did you try to set the print range?

 

[Guest]

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

Thanks . . .