Merged Cells and Wrapped Text

Amr Tabbarah · Dec 22, 2003

I am facing a problem when trying to automatically wrap text for cells
that have been merged. The row height is not changing and is only
showing one line, and I have to change the row height manually.

Does anybody have a solution to this problem?

Thanks.

Gord Dibben · Dec 22, 2003

Amr

Excel has a problem auto-fitting merged cells.

You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

Note also a recent adaptation of this code by Greg Wilson.

http://makeashorterlink.com/?P37D24B15

Gord Dibben Excel MVP

Merged Cells and Wrapped Text

Amr Tabbarah

Gord Dibben