WordWrap Excel 2003

[Tony Cannizzo]

Is there a setting to allow >Format>Cells>Alignment>WordWrap to operate on a
group of merged cells the same way it works on a single cell?

In a single cell, Excel automatically increases the RowHeight to display all
of the text. But in a group of merged cells, you have to manually adjust the
RowHeight to display all the text.

Any help is appreciated.
Thanks

 

[Gord Dibben]

Tony

Merged cells will allow "wrap text" from Format>Cells>Alignment but..........

Excel has a problem auto-fitting merged cells.

You can resize manually or via Macro. Jim Rech has written
code for this which you can incorporate into your own code.

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