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

6

6-shooter

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?
 
G

Gord Dibben

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$1uzL1BHA.1784@tkmsftngp05

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
 
R

ruralkansas

Sometimes you have to merge cells as in the top row labels, etc. I've found
it helpful to wait until I'm finished with my spreadsheet to format any cells
requiring merging.
 
Top