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

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?

--
dhunton

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

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

On Wed, 21 Mar 2007 07:52:05 -0700, dhunton
wrote:

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?

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

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

On Wed, 21 Mar 2007 10:12:13 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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

On Wed, 21 Mar 2007 07:52:05 -0700, dhunton
wrote:

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?