Text wrap in merged cells

[Chuck Dorn]

Is there a way to get text to wrap in cells that have been
merged. Example: A2:C2 are merged cells to get the width
needed. Text is placed in A2 that is greater length than
the merged cells. I would like the text to wrap but can
not seem to get that to happen if cells have been merged.

 

[Mathew Bennett]

Hi Chuck
If the merged cells are A1:C1 and your text is longer than the merged cells,
then try merging cells A1:C2 and also ticking the wrap cells, and the unseen text will apper on row 2.
Yours,
Mathew
Is there a way to get text to wrap in cells that have been
merged. Example: A2:C2 are merged cells to get the width
needed. Text is placed in A2 that is greater length than
the merged cells. I would like the text to wrap but can
not seem to get that to happen if cells have been merged.

 

[Gord Dibben]

Chuck

Merged cells will allow "wrap text" from Format>Cells>Alignment but..........

Excel has a problem auto-fitting merged cells.

Is this your problem?

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

Gord Dibben Excel MVP