Text Wrap

[holy dog]

User has a cell that is set for text wrap. She has textwrap in that the last
line will not show up. Have increased cell height, but text does not show.
Have gotten text to show, but only by widening the cell. This is not an
option because the columns will not fit on one page then. Row height is not
an issue, except that not all of the text will show no matter the height you
make the cell. Does Excel have a limitation on the number of characters can
be in a cell and would this limitation be negated by increasing the width of
the cell/column?

 

[Dave Peterson]

If you add some alt-enters (every 80-100 characters) in that cell, can you see
everything--you may have to resize that rowheight manually, though.

 

[holy dog]

Thank you. I tested this and it works, although the user insists that she
should not need to do this. Oh well.

 

[Dave Peterson]

Did you insist that you shouldn't have to pay taxes?

<vbg>

 

[holy dog]

NO, I wish I would have thought of it then, but then you know the customer is
always right even when they are wrong. I appreciate the help. Thank You
Holy Dog

 

[David McRitchie]

Alt+Enter does gain you an automatic text wrap, but

You probably want to know why the Alt-Enter is needed in some cases
but not in most cases when cell wrap is already turned on.

If you look in HELP you will see that it indicates .under "specification" (specification limits)

Length of cell contents (text)
32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

By using Alt+Enter you can display over 1,024 chars (and/or spaces) in a cell, one
case where specification limits apparently were incorrectly/incompletely documented.
---
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

NO, I wish I would have thought of it then, but then you know the customer is
always right even when they are wrong. I appreciate the help. Thank You
Holy Dog

 

[holy dog]

Thanks, I looked under the help, but did not check specifications. I do
appreciate the assistance and have learned much from you all. These NGs are
the greatest thing since sliced bread

Alt+Enter does gain you an automatic text wrap, but

You probably want to know why the Alt-Enter is needed in some cases
but not in most cases when cell wrap is already turned on.

If you look in HELP you will see that it indicates .under "specification" (specification limits)

Length of cell contents (text)
32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

By using Alt+Enter you can display over 1,024 chars (and/or spaces) in a cell, one
case where specification limits apparently were incorrectly/incompletely documented.
---
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

NO, I wish I would have thought of it then, but then you know the customer is
always right even when they are wrong. I appreciate the help. Thank You
Holy Dog