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?

prevent a cell from breaking and printing on the next page
 

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

prevent a cell from breaking and printing on the next 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