Merged cells.

[David Thomas]

Hi,
Please can someone help me in regards to a merged cell difficulty. When I
type a couple of lines of text into a merged cell, I find that a couple of
things do not happen. First of all I notice that if I do not have wrap text
on, the text does not extend into the next cell. Secondly, when I do have
wrap text on, and type in several lines of text, the row height does not
automatically grow to accomodate the lines of text. I am left to do this
manually which is not as satisfactory.

Can anyone comment on these differences between normal and merged cells.
Regards,
David Thomas.
Melbourne.

 

[Dave Peterson]

That's the way excel works.

If you'd like a macro that you could run that simulates autofitting those rows,
then take a look at this code that Jim Rich posted:
http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

And if you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[David Thomas]

Thanks, that works well.
Do you happen to know why excel works that way? It doesn't appear to be
consistent with the way normal cells operate.

 

[Dave Peterson]

Merged cells are like normal cells <bg>.

I have no insight. If I were guessing, I'd say it was bug. I don't think any
one would design it that way.