Re: How do I "Wrap Text" & "Autofit" within Merged Cells in Excel?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Gord Dibben (gorddibbATshawDOTca)
Date: 10/29/04 

Date: Fri, 29 Oct 2004 15:41:38 -0700

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, 29 Oct 2004 09:54:15 -0700, 6-shooter
<6-shooter@discussions.microsoft.com> wrote:

>Merged cells seem to be treated differently than single cells when it comes
>to this functionality. Are there any tricks to working around this issue?

Quantcast