Row Auto Height Adjust

[Dewayne]

I merge serveral cells within a row (i.e. B2:G2)and then
set the parameters to wrap text. I then adjust the row
height manually to fit the multiple lines of text.
Is there a method of doing the above and having the row
height auto adjust for multiple text lines within the row
of merged cells?
Thanks of any suggstions!
Dewayne

 

[Gord Dibben]

Dewayne

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.

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

The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.

Gord Dibben Excel MVP

 

[Dewayne]

Thank you for your help!
Any suggestion then on the best way to handle text within
Excel?
Thank You

-----Original Message-----
Dewayne

Merged cells will allow "wrap text" from

Format>Cells>Alignment but..........

 

[Gord Dibben]

Dewayne

I don't know if there is a "best way" to handle text within Excel.

Due to the limitations(without extra manipulation) of visible text in a cell
and the coding needed to autofit merged cell row heights you can find Excel
unsuitable in a lot of cases.

Excel is basically a number cruncher and text functions are limited.

On the other hand, Word is built for handling text in large amounts.

Gord