Word wrap - Toolbar short cut??
 

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.
--
Bob

Word wrap - Toolbar short cut??
 

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" wrote:

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.
--
Bob

Word wrap - Toolbar short cut??
 

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


"Vijay Chary" wrote:

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" wrote:

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.
--
Bob

Word wrap - Toolbar short cut??
 

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.
--
Thanks,
Shane Devenshire


"Bob" wrote:

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


"Vijay Chary" wrote:

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" wrote:

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.
--
Bob

Word wrap - Toolbar short cut??
 

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

On Sat, 25 Oct 2008 11:22:00 -0700, ShaneDevenshire
wrote:

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.

Word wrap - Toolbar short cut??
 

Thanks everybody for all your assistance.
--
Bob


"Gord Dibben" wrote:


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

On Sat, 25 Oct 2008 11:22:00 -0700, ShaneDevenshire
wrote:

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.

Word wrap - Toolbar short cut??
 

On Oct 25, 9:52*am, Bob wrote:
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. *
--
Bob

Alt / Enter

ed