F Fletch Mar 25, 2004 #1 If i have merged cells with word wrap on how do I get the cell to automatically expand when lots of text is entered?
If i have merged cells with word wrap on how do I get the cell to automatically expand when lots of text is entered?
G Gord Dibben Mar 25, 2004 #2 Fletch Merged cells will allow "wrap text" from Format>Cells>Alignment but.......... Excel has a problem auto-fitting merged cells. Is this your problem? You can resize manually or via Macro. Jim Rech has written code for this. http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05 Note also a recent adaptation of this code by Greg Wilson. http://makeashorterlink.com/?P37D24B15 Gord Dibben Excel MVP
Fletch Merged cells will allow "wrap text" from Format>Cells>Alignment but.......... Excel has a problem auto-fitting merged cells. Is this your problem? You can resize manually or via Macro. Jim Rech has written code for this. http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05 Note also a recent adaptation of this code by Greg Wilson. http://makeashorterlink.com/?P37D24B15 Gord Dibben Excel MVP
