Why doesn't text wrap in a cell in Excel?

R

rohrbaught

I am typing text in a cell and want it to wrap. I checked "wrap text" box
however it still doesn't wrap and I can only see part of the text. When I
click on the cell the text is there, but I still can't view it if I'm not in
that specific cell.
 
X

X_HOBBES

Is your cell high enough? Try making your cell hight a bit taller. Excel
should automatically adjust the cell height, but that's not always the case.

X_HOBBES
 
P

P Sitaram

Move the mouse to the row number on the left and double-clik on the
bottom border. The row height will auto adjust.
 
A

Amedee Van Gasse

rohrbaught shared this with us in microsoft.public.excel.misc:
I am typing text in a cell and want it to wrap. I checked "wrap
text" box however it still doesn't wrap and I can only see part of
the text. When I click on the cell the text is there, but I still
can't view it if I'm not in that specific cell.
Click to expand...

Press ALT+Enter to insert new lines in the same cell.

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way

How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoynePollard/FGA/questions-with-yes-or-n
o-answers.html
 
R

rohrbaught

You are exactly right...I expanded the height with my cursor and sure enough
the "hidden" text appeared. Thanks!
 
A

Amedee Van Gasse

rohrbaught shared this with us in microsoft.public.excel.misc:
Thanks for responding...I tried this and did not work.
Click to expand...

I'm sorry to hear that. It works for me.
Please note that this does not make the line wrap, it just adds hard
coded line breaks. Please follow Hobbes' instructions.

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way

How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoynePollard/FGA/questions-with-yes-or-n
o-answers.html
 
R

Rivky

You also need to make sure your cell is set to wrap. Right click on
cell. Click format. Alignment tab. Check "Wrap Text"
 
Top