Wrap Text in a cell. No matter what I have tried. Wrap text box is checked.
G Gord Dibben Feb 4, 2005 #3 Is the cell "merged"? Merged cells will allow "wrap text" from Format>Cells>Alignment but.......... Excel has a problem auto-fitting merged cells. 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 The best cure is DON"T USE MERGED CELLS. They cause no end of problems with copying, pasting, sorting, filtering. Gord Dibben Excel MVP
Is the cell "merged"? Merged cells will allow "wrap text" from Format>Cells>Alignment but.......... Excel has a problem auto-fitting merged cells. 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 The best cure is DON"T USE MERGED CELLS. They cause no end of problems with copying, pasting, sorting, filtering. Gord Dibben Excel MVP
