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.

Try Alt + Enter

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"JR Hester" wrote in message
...
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.

Alt+Enter did not work for me at first. I failed to post that I am using
Excel 2000. I did find how this works, only while still in the cell. Once
data is entered and the cell is exited, it does not.

Thabnks for your quick response.

"Sandy Mann" wrote:

Try Alt + Enter

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"JR Hester" wrote in message
...
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.

I have always used:

Format-cells-alignment then select "wrap text"

Suz

"JR Hester" wrote:

Alt+Enter did not work for me at first. I failed to post that I am using
Excel 2000. I did find how this works, only while still in the cell. Once
data is entered and the cell is exited, it does not.

Thabnks for your quick response.

"Sandy Mann" wrote:

Try Alt + Enter

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"JR Hester" wrote in message
...
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.

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.

Your thank you to Sandy is a little ambiguous, I think
you are saying you've got it now,
but specifically Alt+Enter forces a new line within the cell
with a hard line feed which is CHAR(10) which you won't see,
and in doing so it also turns cell wrap that you would otherwise
use Format, cells, alignment, wrap cells. But you can format
entire columns with a wrapped and be done with it in most cases.

But Alt+Enter comes closest to a keyboard shortcut that
turns on cell wrapping which is what you asked for.

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"JR Hester" wrote in message ...
Alt+Enter did not work for me at first. I failed to post that I am using
Excel 2000. I did find how this works, only while still in the cell. Once
data is entered and the cell is exited, it does not.

Thanks for your quick response.

"Sandy Mann" wrote:

Try Alt + Enter

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"JR Hester" wrote in message
...
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 you input.

Sandy:

Thank you so much for this ... it's a real timesaver!!!!

"Sandy Mann" wrote:

Try Alt + Enter

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"JR Hester" wrote in message
...
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.