how do I make the cell expand to fit my text as I type?

[pnwwoman]

I merged some cells across the width of a spreadsheet and i can't get the
cell to increase it's height as more text is typed in wraps around.

 

[kassie]

Only way I know, is to move your cursor to between the row number of therow
you want to adjust and the next row. The cursor changes shape into an
up/down arrow. Click and drag till you see all. Double clicking will also
not work

 

[Gord Dibben]

If cells are merged. the row will not autofit without using VBA

See google search thread for code by Greg Wilson

http://groups.google.com/group/micr...60cbeb27874?lnk=st&q=&rnum=4#ca1c160cbeb27874


Gord Dibben MS Excel MVP

I merged some cells across the width of a spreadsheet and i can't get the
cell to increase it's height as more text is typed in wraps around.

Gord Dibben MS Excel MVP