I am currently experiencing the same problem with Excel only wrapping
certain lines within a cell. This originally occured in a merged cell,
but I experienced the same problem when working with an unmerged cell.
I generally choose to use merged cells for this template because single
row does not provide enough vertical space to meet my needs. I don't
think this is related to the height of the row because manually
adjusting the row height before or after entering the text does not fix
the problem. Hopefully there are other solutions out there somewhere.

Gord Dibben wrote:
You could use event code to autofit the rows with the merged cells.

OR....you coud get rid of the merged cells which can cause no end of problems
with copying, sorting, pasting, filtering and as you have
learned.....autofitting.

The code can be found here.

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

On Tue, 26 Sep 2006 20:01:03 -0700, Meathead
wrote:

I am having the same problem as Will DeLoach.

I have identified the problem to be :
auto row height does not work on merged cells.

If in there are unmerged columns in same row, the auto height will work on
the unmereged cells.

I have tried to do an auto height by highlighting row and clicking on row
hight, this also does not work.

It is really annoying to have to adjust height manually, as this needs to be
done regularly and if you do a global auto adust row hight, the manual row
height reverts back.

Does anybody have an easy work around that does not involve manual
adjustment of row height ?