Re: Auto Expanding Merged Cells

From: Gord Dibben (gorddibbATshawDOTca)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 14:38:29 -0700

John

Merged cells will allow "wrap text" from Format>Cells>Alignment 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?threadm=e1%241uzL1BHA.1784%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 Fri, 11 Jun 2004 12:24:02 -0700, "John" <John@discussions.microsoft.com>
wrote:

>Can anyone tell me how to have excel auto expand merged cells. Right now I have a bunch of merges cells and when you type and it word wraps it doesn't auto expand the cell. Is there something I could do to fix this.

Loading