Excel,Auto fit - does work for large text fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Is there a way to automatically move all rows of a column into text boxes?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merged cell text does not wrap 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Parse Text 1
Wrap Text Help Needed! 3
Row Height - Auto-Fit 1
Transfer information from column 3
# sign appearing in text boxes, Why? 4
How do I print fit to page as in Lotus 97 2

Back
Top