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

Advertisements

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
 
Ad

Advertisements

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