Wrap Text in a cell. No matter what I have tried. Wrap text box is checked.

Try using ALT+Enter where you want to break the text.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"rubenwm" wrote in message
...
Wrap Text in a cell. No matter what I have tried. Wrap text box is
checked.

Is the cell "merged"?

Merged cells will allow "wrap text" from FormatCellsAlignment 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?thre...%40tkmsftngp05

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

On Thu, 3 Feb 2005 13:47:07 -0800, "rubenwm"
wrote:

Wrap Text in a cell. No matter what I have tried. Wrap text box is checked.