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.