How do I auto fit when the cells are merged together? in Excel Worksheet Functions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Christa 11/1/2005 7:53 AM PST
  Question
  I can get the test to wrap around and the cell adjust to size when working
with a single cell but not when the cells are merged together - how to you
get merged cells to auto fit when the text in the merged cell wraps around to
the next line?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Gord Dibben 11/1/2005 10:39 AM PST
  Answer
  Christa

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

Also revised code for special cases.

http://snipurl.com/dfsm


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 Tue, 1 Nov 2005 06:54:02 -0800, "Christa"
<Christa@discussions.microsoft.com> wrote:

>I can get the test to wrap around and the cell adjust to size when working
>with a single cell but not when the cells are merged together - how to you
>get merged cells to auto fit when the text in the merged cell wraps around to
>the next line?

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies