If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel wrap text problem
I am having a problem where we have a lot of text in a
cell. I have the wrap text option turned on and have made the row quite tall. Some of the text is not displaying. There is plenty of white space at the bottom of the row for the text to display, but it does not. If you widen the column, the text will display. However, we don't want the column wider, we want the row taller and to have all of the text display properly. We were able to add hard returns [ALT+ENTER]to manually break the lines at certain spots and have it display, but that seems so manual. Any ideas? Thank you |
#2
|
|||
|
|||
Excel wrap text problem
Hi Ellen,
the specification limit in HELP 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. -- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Ellen Kemper" wrote in message ... I am having a problem where we have a lot of text in a cell. I have the wrap text option turned on and have made the row quite tall. Some of the text is not displaying. There is plenty of white space at the bottom of the row for the text to display, but it does not. If you widen the column, the text will display. However, we don't want the column wider, we want the row taller and to have all of the text display properly. We were able to add hard returns [ALT+ENTER]to manually break the lines at certain spots and have it display, but that seems so manual. Any ideas? Thank you |
#3
|
|||
|
|||
Excel wrap text problem
Thanks for your reply David! I saw those specifications
in help too. My question then is, why does it all display if I widen the column, but it can't display with a taller row? Thanks, Ellen -----Original Message----- Hi Ellen, the specification limit in HELP 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. -- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Ellen Kemper" wrote in message news:01f001c3aaf7$15c74210 ... I am having a problem where we have a lot of text in a cell. I have the wrap text option turned on and have made the row quite tall. Some of the text is not displaying. There is plenty of white space at the bottom of the row for the text to display, but it does not. If you widen the column, the text will display. However, we don't want the column wider, we want the row taller and to have all of the text display properly. We were able to add hard returns [ALT+ENTER]to manually break the lines at certain spots and have it display, but that seems so manual. Any ideas? Thank you . |
#4
|
|||
|
|||
Excel wrap text problem
Are you within specifications and do you really see all of the text
if you widen the row. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Ellen" wrote in message ... Thanks for your reply David! I saw those specifications in help too. My question then is, why does it all display if I widen the column, but it can't display with a taller row? Thanks, Ellen -----Original Message----- Hi Ellen, the specification limit in HELP 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. -- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Ellen Kemper" wrote in message news:01f001c3aaf7$15c74210 ... I am having a problem where we have a lot of text in a cell. I have the wrap text option turned on and have made the row quite tall. Some of the text is not displaying. There is plenty of white space at the bottom of the row for the text to display, but it does not. If you widen the column, the text will display. However, we don't want the column wider, we want the row taller and to have all of the text display properly. We were able to add hard returns [ALT+ENTER]to manually break the lines at certain spots and have it display, but that seems so manual. Any ideas? Thank you . |
#5
|
|||
|
|||
Excel wrap text problem
No, I am beyond the specifications (my last test was
1,113 characters not counting spaces and 1418 if you do count spaces) but still when you widen the column, you see it all. Also, if you use [ALT+ENTER] to place hard returns in the midst of the text, you can force it to wrap down to more lines, although obviously this is a very manual process. When you cut back to 1024 characters, it will all wrap correctly as long as the column is wide enough that you don't break the 409 point row height specification. I guess the conclusion to come to is that it will act unpredictably if you go above the specifications. Thanks for your input. Ellen -----Original Message----- Are you within specifications and do you really see all of the text if you widen the row. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Ellen" wrote in message ... Thanks for your reply David! I saw those specifications in help too. My question then is, why does it all display if I widen the column, but it can't display with a taller row? Thanks, Ellen -----Original Message----- Hi Ellen, the specification limit in HELP 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. -- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Ellen Kemper" wrote in message news:01f001c3aaf7$15c74210 ... I am having a problem where we have a lot of text in a cell. I have the wrap text option turned on and have made the row quite tall. Some of the text is not displaying. There is plenty of white space at the bottom of the row for the text to display, but it does not. If you widen the column, the text will display. However, we don't want the column wider, we want the row taller and to have all of the text display properly. We were able to add hard returns [ALT+ENTER]to manually break the lines at certain spots and have it display, but that seems so manual. Any ideas? Thank you . . |
Thread Tools | |
Display Modes | |
|
|