Why Excel doens't display all text in a cell

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I have quite a bit text entered in a cell. But Excel doesn't display all. I
tried wrap text, merge cell, but none worked. All text is in there when I
click the cell. How can I make it display all? Thanks.
 
If you add alt-enters to your text (to force new lines within the cell), you can
see more of the text.
 
Thanks for the help. Tried that, didn't work.

Dave Peterson said:
If you add alt-enters to your text (to force new lines within the cell), you can
see more of the text.
Click to expand...
 
Dan, I think that Only 1,024 characters will display in a cell
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
How many characters are in that cell:

=len(a1)
if the cell is a1

How many alt-enters did you insert? I've found every 80-100 characters helps.


Yes. I got margin instead of text at top no matter how big I made it.
Click to expand...
 
length: 1752. alt-enter: 3. I didn't have alt-enter within paragraphs cause
I wanted them to wrap accordingly when width changed.
 
I think you have a choice to make. Insert lots more alt-enters or live with
what you see.

I don't know of any other way.

(well, how about a text box?)
length: 1752. alt-enter: 3. I didn't have alt-enter within paragraphs cause
I wanted them to wrap accordingly when width changed.
Click to expand...
 
Thanks, Dave.

Dave Peterson said:
I think you have a choice to make. Insert lots more alt-enters or live with
what you see.

I don't know of any other way.

(well, how about a text box?)
Click to expand...
 
Back
Top