Leo

Merged cells will allow "wrap text" from FormatCellsAlignment 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?thre...%40tkmsftngp05

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

On Sat, 22 Jan 2005 11:53:05 -0800, Leo wrote:

I am using Excel 2002 run on a Windows XP machine. In a cell I have typed a
bunch of text. I selected "wrap text" in the format of the cell. It is also a
merged cell with severl cells to the right. On one tab of the workbook, when
I double click on the row seperation line to the left it will automatically
change the hieght of the row to fit the content, keeping the column width
fixed. On the second tab in the work book when I do this or select "autofit"
from the format/row menu, the row will shrink to the height of one line of
text and nothing more. Is there some setting that is causing this? I have a
large number of rows and have to manually adjust them one at a time instead
of being able to double click and autofit them.