Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lu
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
davesexcel
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
Lu
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Weird auto page breaking that I can't get rid of... creativeops Excel Discussion (Misc queries) 6 June 15th 07 04:22 AM


All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"