making a cell resize itself to accommodate data

yawnmoth · External Since: Nov 04, 2009 Posts: 1

I have an Excel spreadsheet with a cell that I'd like to make, by
default, the size of two ordinary cells. I can insert a new row
underneath it and then merge that new row with the row I want to make
larger but if I do that the cell no longer resizes itself to
accommodate data.

Some of the existing rows are the size of two or so cells (in terms of
height) but, as right clicking on them and going to the Format
Cells... option on the resultant menu shows, they're not the result of
two merged cells - they're just one cell whose height has been
increased. And when you insert data, the cell resizes to accommodate
the data much an HTML element whose width or height have not been
explcitely specified.

That's what I'd like to do but I can't figure out how.

Any ideas?

Gord Dibben · External Since: Feb 23, 2004 Posts: 9178

Merged cells will wrap text but not Row>Autofit to accomodate data.

If you MUST use merged cells you will need VBA event code to autofit the
rows with merged cells.

See google search thread for code by Greg Wilson. Watch out for word wrap
in the URL which all one line.

http://groups.google.com/group/microsoft.public.excel.misc/browse_frm/...ead/229

Gord Dibben MS Excel MVP

On Wed, 4 Nov 2009 15:31:37 -0800 (PST), yawnmoth <terra1024 RemoveThis @yahoo.com>
wrote:

>I have an Excel spreadsheet with a cell that I'd like to make, by
>default, the size of two ordinary cells. I can insert a new row
>underneath it and then merge that new row with the row I want to make
>larger but if I do that the cell no longer resizes itself to
>accommodate data.
>
>Some of the existing rows are the size of two or so cells (in terms of
>height) but, as right clicking on them and going to the Format
>Cells... option on the resultant menu shows, they're not the result of
>two merged cells - they're just one cell whose height has been
>increased. And when you insert data, the cell resizes to accommodate
>the data much an HTML element whose width or height have not been
>explcitely specified.
>
>That's what I'd like to do but I can't figure out how.
>
>Any ideas?