Text-wrap issue

**mark-ainsworth** · 09-04-2010, 06:47 AM

Hi,

Please see the excel sheet attached.

I have cells on the sheet that i want it to wrap the text and automatically make the row taller if needed - i can't seem to crack it. An example cell is E9:H9 (merged).

Could someone tell me how do do it?

Many Thanks,

Mark

**teylyn** · 09-04-2010, 07:01 AM

Hello Mark,

bad news: Merged cells do not respond to autofit of row height. Actually, merged cells do not respond well to a lot of things in Excel and should be avoided.

You will need to adjust the row height of the merged cell manually.

**pike** · 09-04-2010, 07:12 AM

Hi mark-ainsworth
a work-a-round is to size a cell (off screen and in the same row) to the same width as the meged cells. then text wrap that cell. it will auto size the merged area.

**Cheeky Charlie** · 09-04-2010, 09:53 AM

a work-a-round is to size a cell (off screen and in the same row) to the same width as the meged cells. then text wrap that cell. it will auto size the merged area.

This will work, but I'd second the recommendation to avoid merged cells altogether - it will pay dividends in the long run!