How about a toggle macro you can assign to a shortcut key combo of your choice,
like CTRL + e

Sub Wrap_Text()
With Selection
.WrapText = Not .WrapText
End With
End Sub

CTRL +e toggles wrap text on/off for selected cells.


Gord Dibben MS Excel MVP


On Tue, 6 Feb 2007 10:40:01 -0800, JR Hester
wrote:

Anyone know of a keyboard shortcut to turn text wrap "on". One of my
co-workers "remembers" the capability, but not the keystrokes, from an
ancient class. I can only come up with Alt+O, E, Alt+W or Ctrl+1, A, Alt+W.
Is there a little known, or unknown, that I have missed to activate this
feature for a cell?

Thanks for yoru input.