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

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top