wrap command shortcut

[Dingbat]

Hi there.
I've looked in the customise toolbar but maybe not well enough. In Excel
2003, I'm looking for a way of being able to just click one button/icon to
wrap text in a cell. I need to do this a lot and would like not to have to
right click, go to the format cell>alignment tab.
Anyone know?

 

[Shane Devenshire]

Sorry, that button did not exist in 2003 it was added in 2007. You can
record a macro to do it and assign it to a custom button. If you put the
macro in the Personal Macro Workbook it will be available on that machine all
the time.

Sub WrapText()
' Keyboard Shortcut: Ctrl+Shift+W
Selection.WrapText = True
End Sub

You might also assign a shortcut key as I did in the above example.

 

[Dingbat]

O good. I'll definitely do that.
Thank you

Sorry, that button did not exist in 2003 it was added in 2007. You can
record a macro to do it and assign it to a custom button. If you put the
macro in the Personal Macro Workbook it will be available on that machine
all
the time.

Sub WrapText()
' Keyboard Shortcut: Ctrl+Shift+W
Selection.WrapText = True
End Sub

You might also assign a shortcut key as I did in the above example.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

 

[Héctor Miguel]

hi, guys !

(just in case) if you need to make it to work "like a toggle button" (?)...

Selection.WrapText = Not Selection.WrapText

hth,
hector.

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP