I added a bunch of alt-enters into a cell that contained lots of text. I
changed the font size (slightly smaller) and widened the column. I adjusted the
rowheight manually and did a print preview.

It showed all 4401 characters in the cell. (I didn't print to paper, though.)

I used a formula to put some text into that cell:
=REPT(REPT("asdf ",35)&CHAR(10),25)&"X"

You may want to just try adding a few/lots of alt-enters to one cell to see if
that helps.



ancastle wrote:

How can I make a large text field display all the lines on my spreadsheet and
when I print it.

--

Dave Peterson