Text Wrap

G

Guest

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

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.
 
G

Guest

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

Guest

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
 
D

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.


holy dog said:
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
Click to expand...
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

wrap text 1
Wrap text in cell 1
2007 Excel: text in cell becomes hidden when formatted to wrap tex 0
Word wrap and height 1
Automatic row height adjust 1
Excel Typed text appears in wrong cell 0
Why does my text in a cell with wrap text and auto height get cut 4
Excel 2007 Character Display 2

Top