Why Excel doens't display all text in a cell
 

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.



Dan wrote:

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

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

"Dave Peterson" wrote in message
...
If you add alt-enters to your text (to force new lines within the cell),
you can
see more of the text.



Dan wrote:

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

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


"Dan" wrote in message
...
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.

Dan

Is your text aligned to the left?

George Gee


*Dan* has posted this message:

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

"Dave Peterson" wrote in message
...
If you add alt-enters to your text (to force new lines within the
cell), you can see more of the text.



Dan wrote:

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

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

Paul B wrote:

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

"Dan" wrote in message
...
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

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


"George Gee" wrote in message
...
Dan

Is your text aligned to the left?

George Gee


*Dan* has posted this message:

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

"Dave Peterson" wrote in message
...
If you add alt-enters to your text (to force new lines within the
cell), you can see more of the text.



Dan wrote:

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

Alt-enter is what I used.

"Dave Peterson" wrote in message
...
Not if you pepper lots of alt-enters within the cell.

Paul B wrote:

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

"Dan" wrote in message
...
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

Did you adjust the row height manually?

Dan wrote:

Alt-enter is what I used.

"Dave Peterson" wrote in message
...
Not if you pepper lots of alt-enters within the cell.

Paul B wrote:

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

"Dan" wrote in message
...
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

--

Dave Peterson

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

"Dave Peterson" wrote in message
...
Did you adjust the row height manually?

Dan wrote:

Alt-enter is what I used.

"Dave Peterson" wrote in message
...
Not if you pepper lots of alt-enters within the cell.

Paul B wrote:

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

"Dan" wrote in message
...
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

--

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.



Dan wrote:

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

"Dave Peterson" wrote in message
...
Did you adjust the row height manually?

Dan wrote:

Alt-enter is what I used.

"Dave Peterson" wrote in message
...
Not if you pepper lots of alt-enters within the cell.

Paul B wrote:

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

"Dan" wrote in message
...
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

--

Dave Peterson

--

Dave Peterson

"Dave Peterson" wrote in message
...
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 wrote:

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

"Dave Peterson" wrote in message
...
Did you adjust the row height manually?

Dan wrote:

Alt-enter is what I used.

"Dave Peterson" wrote in message
...
Not if you pepper lots of alt-enters within the cell.

Paul B wrote:

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

"Dan" wrote in message
...
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

--

Dave Peterson

--

Dave Peterson

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" wrote in message
...
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 wrote:

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

"Dave Peterson" wrote in message
...
Did you adjust the row height manually?

Dan wrote:

Alt-enter is what I used.

"Dave Peterson" wrote in message
...
Not if you pepper lots of alt-enters within the cell.

Paul B wrote:

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

"Dan" wrote in message
...
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

--

Dave Peterson

--

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

Dan wrote:

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" wrote in message
...
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 wrote:

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

"Dave Peterson" wrote in message
...
Did you adjust the row height manually?

Dan wrote:

Alt-enter is what I used.

"Dave Peterson" wrote in message
...
Not if you pepper lots of alt-enters within the cell.

Paul B wrote:

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

"Dan" wrote in message
...
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

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson

Thanks, Dave.

"Dave Peterson" wrote in message
...
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?)

Dan wrote:

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" wrote in message
...
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 wrote:

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

"Dave Peterson" wrote in message
...
Did you adjust the row height manually?

Dan wrote:

Alt-enter is what I used.

"Dave Peterson" wrote in message
...
Not if you pepper lots of alt-enters within the cell.

Paul B wrote:

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

"Dan" wrote in message
...
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

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson