Text wrap in merged cells

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.

you need to adjust the height of the row.

"Chuck Dorn" wrote in 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.

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

This only works on cells that have not been merged.
-----Original Message-----

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

Chuck

See answer in .excel.misc

Gord Dibben Excel MVP


On Wed, 21 Jan 2004 08:46:36 -0800, "Chuck Dorn" wrote:

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.