The best solution is not to use merged cells - they're far more trouble
than they're worth. If you're merging in order to center a title, do
this instead: put the title in A1. Select A1:D1. Choose
Format/Cells/Alignment and select "Center Across Selection" from the
Horizontal dropdown.

If you need to keep the cells merged, then you'll need to use something
like this macro by Jim Rech:

http://groups.google.com/group/micro...amming/browse_
frm/thread/a5cbe0ee8e6c2a10/93c6bca447bd8902#93c6bca447bd8902

(or http://elfurl.com/2gguv, if the above linewrapped link doesn't work)

In article ,
Lena_Office wrote:

I have a file where I have merged cells a10:d:10 and formatted it to wrap
text.
My problem is that the row-height not changes automatically, which always
happends if I wrap text in cells that are not merged.
I there any sulotion for this?