How can I wrap text across merged cells?

  • Thread starter Thread starter Ivy
  • Start date Start date
I

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?
 
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
 
Back
Top