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

[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

 

[Jim Rech]

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.

 

[JoAnn]

Thanks!