Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How can I use word wrap in a merged cell in excel 2000? | Excel Discussion (Misc queries) | |||
How can I Excel to re-size when wrapping text in merged cells | Excel Discussion (Misc queries) | |||
I have typed in an excel cell and cannot advance to next cell by . | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |