Excel,Auto fit - does work for large text fields
 

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

About 1024k of characters will print, otherwise you'd need to use a text box

Regards,

Peo Sjoblom

"ancastle" wrote:

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

Oops! Not 1024k, about 1kb or 1024 characters

Regards,

Peo Sjoblom

"Peo Sjoblom" wrote:

About 1024k of characters will print, otherwise you'd need to use a text box

Regards,

Peo Sjoblom

"ancastle" wrote:

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

Is there a way to automatically move all rows of a column into text boxes?

"ancastle" wrote:

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

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