JAM

Question 1.

There is no shortcut command unless you roll your own in VBA.

To toggle wrap text on/off......assign to a button or shortcut key combo.

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

Question 2.

If pre-formatted to wrap text, the text will not extend across, otherwise it
will extend.


Gord Dibben Excel MVP


On Wed, 23 Feb 2005 13:05:06 -0800, "JAM_Analyst"
wrote:

When cells in a spreadsheet are populated with text, is there a shortcut
command that can be added to the toolbar for 'wrap text'?

Also, when there is a long text string entered in a cell, it appears across
multiple [blank] cells in that row automatically. If this is a formatting
feature, how/where can I access this option?