Row Height Issue

[Guest]

Hi,

I'm having a fun time with Excel 2000, merged cells and row heights! I have
a worksheet with rows of merged cells that span 14 columns. Text is entered
into these merged cells and it often wraps to multiple lines. When I try to
use the Format -> Row -> Autofit function it simply reduces the row height to
the default 12.75, and most of the text becomes hidden. The same thing
happens when I double click the border around the row number at the left of
the window.

This seems counter-intuitive to me. Is there something I'm missing here or
are merged cells not recognized by the autofit function?

Thanks!

SM

 

[Gord Dibben]

SM

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