Newbie question - how to keep cell ranges together when printing?

  • Thread starter Thread starter JoAnn
  • Start date Start date
J

JoAnn

Hi,

Is there a way to flag selected cell ranges to always stay
together when they print? In Word they have a "keep lines
together" option -- is there anything comparable in Excel
to ensure that selected cells/rows stay together on a page
even when new information is added (not only within the
selected range but also when additional cell ranges are
added)?

I need to ensure that the cell ranges aren't split by page
breaks. I currently use print preview to see where they
are breaking once I add new information and then move the
page breaks before printing.

Since new information is constantly being added to the
worksheet I am looking for a "set-it-and-forget-it" way to
ensure that selected cell ranges of information always
stay together on a printed page.

Thanks for your help!
JoAnn
 
There is nothing similar in Excel to the Word feature you described, which
would be useful. What you're doing now I think is a pretty good way to go.
Of course if you put a page break above this region you could be sure it
would always be together, at the cost of the previous page sometimes having
a lot of unused space.
 
Back
Top