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

--
David M. Marcovitz
Microsoft PowerPoint MVP
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/