A
ancastle
How can I make a large text field display all the lines on my spreadsheet and
when I print it.
when I print it.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
About 1024k of characters will print, otherwise you'd need to use a text box
Regards,
Peo Sjoblom
Regards,
Peo Sjoblom
P
Peo Sjoblom
Oops! Not 1024k, about 1kb or 1024 characters
Regards,
Peo Sjoblom
Regards,
Peo Sjoblom
A
ancastle
Is there a way to automatically move all rows of a column into text boxes?
D
Dave Peterson
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.
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.