Row height not auto adjusting on wrapped cells (Excel '07)

D

Dave

I have a worksheet with cells that I want the text to wrap. I turned on text
wrapping for the entire worksheet but the text in the cells won't wrap.

I have read through a bunch of posts from people having similar issues to
mine in other versions of Excel and have done everything recommended:
I removed and verified that there are no merged cells anywhere in the
worksheet. I turned protection off for the entire sheet. I checked that the
wrap text box in format cells -> alignment is checked and not shaded (when
the entire worksheet is selected). When I highlight all of the rows being
used, the wrap text button lights up. When I highlight all of the columns
being used, the wrap text button lights up. What am I missing?

Some reference an AutoFit option but I can't find it in '07. Is there a
macro I should be using?

Any help is appreciated.
 
B

Bernard Liengme

You have to tell Excel where to start a new line?
Try this:
1) type the word "apple"
2) hold the ALT key and tap the ENTER key
3) type the word "pie"
You should see one word over the other
best wishes
 
D

Dave

I tried your suggestion in a cell that is formatted to wrap and nothing
happens. The cell did not resize (get taller) automatically to show "pie".

If I have to put a hard return in, then there is no reason to have the wrap
text option. I am looking for an option/macro that will automatically size
the row as the text goes beyond the width of the column. Maybe I am not
understanding what text wrapping means in Excel. I will just reformat the
sheet with "taller" rows so the text will be readable.

Thanks
 

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

Top