Why Excel doens't display all text in a cell

[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.

 

[Dave Peterson]

If you add alt-enters to your text (to force new lines within the cell), you can
see more of the text.

 

[Dan]

Thanks for the help. Tried that, didn't work.

If you add alt-enters to your text (to force new lines within the cell), you can
see more of the text.

 

[Paul B]

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

 

[George Gee]

Dan

Is your text aligned to the left?

George Gee


*Dan* has posted this message:

 

[Dave Peterson]

Not if you pepper lots of alt-enters within the cell.

 

[Dan]

George, Yes. I have it left-aligned with wrap text and merge cell selected.

 

[Dan]

Alt-enter is what I used.

Not if you pepper lots of alt-enters within the cell.

 

[Dave Peterson]

Did you adjust the row height manually?

Alt-enter is what I used.

 

[Dan]

Yes. I got margin instead of text at top no matter how big I made it.

 

[Dave Peterson]

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.

 

[Dan]

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.

 

[Dan]

length: 1752. alt-enter: 3. I didn't have alt-enter within paragraphs cause
I wanted them to wrap accordingly when width changed.

 

[Dave Peterson]

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.

 

[Dan]

Thanks, Dave.

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?)