How can I wrap text across merged cells?

[Ivy]

I'm using Excel 2000. I have a set of merged cells A5-
E5. I have several lines
of text in the cells and I want them to wrap across the
merged cells and it is not working. All I get is the
first line of text showing and the rest is cut off. It
works if the cells are not merged, but I really need to do
it in my merged cells. Is there a way to this other than
manually resizing the height of the row?

 

[RagDyer]

Instead of merging cells, have you tried the "Center Across Selection"
option ?
The appearence is just about identical to what you would get using merged
cells, although I don't know your requirements for wanting to use merge.

Another approach where you wouldn't need to manually resize the rows, if you
knew the approximate size of the text beforehand, is to merge your cells
*both* horizontally *and* vertically and use the <Alt> <Enter> for a forced
line break (word wrap).

HTH

RD

 

[Gord Dibben]

Ivy

Wrap text works on merged cells. Autoheight does not. Perhaps this is what
you are experiencing. 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 XL2002