Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text Wrapping Command
Please help, I am unsure if there is a command that can be added to the
toolbar but if there is one for text wrapping in a cell or a keyboard shorcut could somebody please tell me, thank you. |
#2
|
|||
|
|||
you can make a quick macro such as
Sub wrp() With Selection .WrapText = True End With End Sub then add a macro button to the toolbar and assign this macro to it or <tools<macros<options and assign a keyboard shrortcut. "Anthonyd" wrote: Please help, I am unsure if there is a command that can be added to the toolbar but if there is one for text wrapping in a cell or a keyboard shorcut could somebody please tell me, thank you. |
#3
|
|||
|
|||
Or a toggle on/off macro.
Sub Wrap_Text() With Selection .WrapText = Not .WrapText End With End Sub Gord Dibben Excel MVP On Mon, 9 May 2005 07:14:13 -0700, "bj" wrote: you can make a quick macro such as Sub wrp() With Selection .WrapText = True End With End Sub then add a macro button to the toolbar and assign this macro to it or <tools<macros<options and assign a keyboard shrortcut. "Anthonyd" wrote: Please help, I am unsure if there is a command that can be added to the toolbar but if there is one for text wrapping in a cell or a keyboard shorcut could somebody please tell me, thank you. |
#4
|
|||
|
|||
Thanks BJ.
"bj" wrote: you can make a quick macro such as Sub wrp() With Selection .WrapText = True End With End Sub then add a macro button to the toolbar and assign this macro to it or <tools<macros<options and assign a keyboard shrortcut. "Anthonyd" wrote: Please help, I am unsure if there is a command that can be added to the toolbar but if there is one for text wrapping in a cell or a keyboard shorcut could somebody please tell me, thank you. |
#5
|
|||
|
|||
Thank you Gord.
"Gord Dibben" wrote: Or a toggle on/off macro. Sub Wrap_Text() With Selection .WrapText = Not .WrapText End With End Sub Gord Dibben Excel MVP On Mon, 9 May 2005 07:14:13 -0700, "bj" wrote: you can make a quick macro such as Sub wrp() With Selection .WrapText = True End With End Sub then add a macro button to the toolbar and assign this macro to it or <tools<macros<options and assign a keyboard shrortcut. "Anthonyd" wrote: Please help, I am unsure if there is a command that can be added to the toolbar but if there is one for text wrapping in a cell or a keyboard shorcut could somebody please tell me, thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does Excel 2003 have a shortcut command to wrap text in a cell? | Excel Discussion (Misc queries) | |||
text wrapping in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I fix text wrapping in Excel? | Excel Discussion (Misc queries) | |||
Text wrapping problems | Excel Worksheet Functions | |||
Command: If the contents (text not numerical) of A1 in Sheet2 are. | Excel Worksheet Functions |