E Emily Aug 19, 2003 #1 Is it possible to use text wrapping in merged cells? So far I've had no luck making it work.
M mary Aug 19, 2003 #2 Yes, just highlight the cells you want to merge and wrap. Right click and go to format cells. On the Allignment tab at the bottom, check wrap text and merge. It should work fine. Mary
Yes, just highlight the cells you want to merge and wrap. Right click and go to format cells. On the Allignment tab at the bottom, check wrap text and merge. It should work fine. Mary
G Gord Dibben Aug 20, 2003 #3 Emily Wrap text works on merged cells. Autoheight does not. 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 XL2002
Emily Wrap text works on merged cells. Autoheight does not. 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 XL2002
