Shortcut for text Wrap

[Guest]

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.

 

[Sandy Mann]

Try Alt + Enter

--
HTH

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

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.

 

[Guest]

I have always used:

Format->cells->alignment then select "wrap text"

Suz

 

[Gord Dibben]

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

 

[David McRitchie]

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.

 

[Mares]

Sandy:

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

 

[ketusirsat]

Hi Everyone,
You can Try This for Excel 2007 and above:-
"Alt+H" then "W"

Ketak Sirsat,
VBA Specialist and Excel Expert,
TATA Consultancy Services.
Bangalore.
Mail : (e-mail address removed)