Excel merged cell - can it automatically expand as text is typed?
 

I have merged two cells and want it to expand (get bigger) as more text is
typed or added.

I'm able to do this with just a single cell (row autofit, wrap text), but
when I merge two or more cells, these options no longer work.

I don't think you can and-in my opinion-it's just another reason to stay away from merged
cells.

--
Regards;
Rob
------------------------------------------------------------------------
"Joanne (JAS)" <Joanne wrote in message
...
I have merged two cells and want it to expand (get bigger) as more text is
typed or added.

I'm able to do this with just a single cell (row autofit, wrap text), but
when I merge two or more cells, these options no longer work.

Take a look at the macro by Jim Rech:


http://groups-beta.google.com/group/...programming/br
owse_frm/thread/c681ec7915bee300/2601d8ed556c55e9?


In article ,
Joanne (JAS) <Joanne wrote:

I have merged two cells and want it to expand (get bigger) as more text is
typed or added.

I'm able to do this with just a single cell (row autofit, wrap text), but
when I merge two or more cells, these options no longer work.