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

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

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

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.

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

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