INCREASING THE # OF TEXT ALLOWED IN A CELL?

[ullas]

Hi, I would love to know how you can increase the number of text allowed in a
cell when using Excel. I use excel a lot and put in a lot of text in colums
but what I find is when the number of text increases to greater than 250 the
text is not visible on the cell even after I increase the size so it is not
visible when I print the data. Any help on this would be great.

Thank you.

 

[Dave Peterson]

Try adding alt-enters to force newlines within the cell. Depending on the
amount of text in those cells, you may have to adjust the rowheight manually.

And if that doesn't help...

Are you using multiple monitors?

 

[ullas]

Thanks for your response Dave. I know about the Alt-enters which I use quite
a bit, but what seems to happen is when I enter more than a certain number of
text I think it is about 250 it does not display on the column it seems to
right indent and is not visible when you print. I think excel has a limit on
the number of text you can view. Do you know if that can be increased?

 

[JE McGimpsey]

Without the manual linefeeds, XL's limit (see "Specifications" in XL
Help) is 1024 characters displayed or printed. That limit cannot be
changed.

 

[Dave Peterson]

xl97-xl2003's help shows that it'll display about 1000 characters in a cell. By
using alt-enters and a small font, I've seen 5k to 15k characters in the cell.

You can use
=len(a1)
to show the number of characters in A1.

You didn't answer my question.