How do I make all "lines" in my row print on the same page?

[Guest]

I have a spreadsheet in Excel in which many of the cells have text that wrap
to two or three lines. When I print this, I don't want any of the cells to
print on more than one page (i.e. the first line is on page 1, but lines 2 &3
are on page 2).

Is there a way to require the entire row to print together?

 

[Gord Dibben]

Excel inserts pagebreaks before or after entire rows, not in the middle of wrap
text/autofit rows.

I cannot replicate your problem.

Or are you just thinking ahead and haven't actually tried to print yet.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Just an added note.

I can replicate your problem if the you have "merged cells" with the text in
them.

Excel will pagebreak in the middle of merged cells.

One more reason to avoid them like the plague.


Gord