Word wrap - Toolbar short cut??

[Bob]

Perhaps I just can't find it in the Customize Commands list, but is there a
short command button for wordwrapping, and if not, why not? There are short
cuts for every other kind of formatting except this.

 

[Vijay Chary]

Hi Bob !
Here's the method ! Type in a cell that's not formatted
'word wrap'. Record a macro (You'll find instuctions in Excel's Help) and
word wrap the cell manually. Stop recording. Now you have a macro for word
wrapping. Customize your tool bar (Excel 97-2003) / quick access toolbar
(Excel 2007) and put a button in it that triggers the macro when clicked on.

I hope the info. is useful to you ! Good Luck !

Vijay

 

[Bob]

Thank you Vijay, that gives me a fix. But it is curious to me why Microsoft
never created a short cut command for it....maybe it was over-looked?

Thanks again.
--
Bob

Hi Bob !
Here's the method ! Type in a cell that's not formatted
'word wrap'. Record a macro (You'll find instuctions in Excel's Help) and
word wrap the cell manually. Stop recording. Now you have a macro for word
wrapping. Customize your tool bar (Excel 97-2003) / quick access toolbar
(Excel 2007) and put a button in it that triggers the macro when clicked on.

I hope the info. is useful to you ! Good Luck !

Vijay

:

Perhaps I just can't find it in the Customize Commands list, but is there a
short cut command button for word wrapping, and if not, why not? There are
short cuts for every other kind of formatting except this.
--

 

[ShaneDevenshire]

Hi,

Actually Microsoft has addressed this issue - Excel 2004 (Mac) has this
toolbar button & Excel 2007 (PC) also has it.

In 2003 use the following code

Sub WordWrap()
Selection.WrapText = True
End Sub

I would assign the shortcut key Ctrl+Shift+W or maybe Ctrl+e

Not Ctrl+W because it is already taken, it means Close. Also, I would
record the macro into the Personal Macro Workbook so it would be available in
all of your files. The recording will be longer than the above code, but you
can change it to mine once you've recorded it.

If this helps, please click the Yes button.

 

[Gord Dibben]

Slight revision to make it a toggle function.

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


Gord Dibben MS Excel MVP

 

[Bob]

Thanks everybody for all your assistance.

 

[ed]

Perhaps I just can't find it in the Customize Commands list, but is therea
short command button for wordwrapping, and if not, why not?   There areshort
cuts for every other kind of formatting except this.  

Alt / Enter

ed