David

If cells are merged. the row will not autofit even with wrap text enabled
without using VBA

See google search thread for code by Greg Wilson

http://groups.google.com/group/micro...1c160cbeb27874

Second piece of advice is.............get rid of the merged cells.

They cause no end of problems with copying, pasting, sorting, filtering,
autofitting and a few(many?) others that have slipped my mind at present.


Gord Dibben MS Excel MVP

On Tue, 03 Jun 2008 07:25:25 -0700, "David M. Marcovitz"
wrote:

I am using Excel 2003. I need to merge the cells in most of columns C
and D (e.g. C2 is merged with D2, C3 is merged with E3, etc.). Merging
is not a problem. I also need to wrap text in those newly merged cells.
That is not a problem. The problem arises when I try to autofit the text
in the merged and wrapped cells. Any attempt to autofit cuts off the
cells at one line of text. If I remove the merging, the autofit works
perfectly.

For example, if the merged C2&D2 contains:

This is my comment to you. You
are doing very well. I hope that
you continue to do this well on
the rest of your assignments.

Autofit will shrink the height of the line to just show:

This is my comment to you. You

Is there anything that I can do about this? It is possible to redesign
the worksheet so that the cells are not merged, but this is a pain and
produces results that are not quite what is needed. Please help. Thanks.

--David