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.

 

[Naraine]

you need to adjust the height of the row.

 

[Guest]

-----Original Message-----
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.
.

To make it wrap, right click on the merged cell and
select "format cell" from the list displayed. The dialog
box opens and select the alignment tab. In the alignment
dialog box will be a checkbox selection to wrap text.

 

[Guest]

This only works on cells that have not been merged.

 

[Gord Dibben]

Chuck

See answer in .excel.misc

Gord Dibben Excel MVP