Auto size row

I can't seem to merge cells and wrap text and have the row
automatically size itself to fit the data.

If you wrap text in a single cell it works, does anyone
know how to make it work in merged cells.

Merged cells will not auto-wrap.
Row has to be enlarged manually.

If your merged cells are strictly across columns within the same row, have
you tried the "CenterAcrossSelection" option in:
Format Cells Alignment tab,
Expand the "Horizontal" box and click,
CenterAcrossSelection.

This gives the same display characteristics as merged cells, without all the
other problems associated with those !#%$@&^! merged cells !
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"mgolden" wrote in message
...
I can't seem to merge cells and wrap text and have the row
automatically size itself to fit the data.

If you wrap text in a single cell it works, does anyone
know how to make it work in merged cells.

Ragdyer's suggestion to "center across selection" is easiest and least
troublesome.

If you really must use merged cells, which will cause problems later with
copy/paste/sort/filtering to name a few.

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

Gord Dibben Excel MVP

On Tue, 10 Feb 2004 14:29:32 -0800, "mgolden"
wrote:

I can't seem to merge cells and wrap text and have the row
automatically size itself to fit the data.

If you wrap text in a single cell it works, does anyone
know how to make it work in merged cells.