I'm using Excel 2007, and am running into a formatting issue.

Lets say I have merged cells A2, A3, A4 & A5. I have also set the text to wrap, and set the row to Autoheight.

My problem is the merged cell does not automatically adjust in height. The text does wrap properly, and I can manually adjust the row height to display the text properly. If I unmerge the cells, the information in A2 does Wrap and AutoHeight correctly.

This has something to do with the merging of the cells.

I can take contents of the merged cell and place the value in another cell. Lets say in cell A10, I use a formula "=A2", if the cell width is set to the same as the merged cells it will format correctly. By that I mean cell A10 will wordwrap and Autoheight correctly, and with the height of the row changing, Now cell A2 display correctly. This is my current work around.

Any thoughts would be appreciated