Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
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 |
#10
|
|||
|
|||
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 |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
"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 |
#13
|
|||
|
|||
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 |
#14
|
|||
|
|||
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 |
#15
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dont display the colors on the Cell ( Excel 2003 ) | New Users to Excel | |||
Why does Excel display 01/12/2005 as 38364 when the cell value is. | Excel Discussion (Misc queries) | |||
How I do I rotate text in an excel cell? The rotate commands is g. | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
in excel how to display results of a function and text in the sam. | Excel Worksheet Functions |