Does Excel 2003 have a shortcut command to wrap text in a cell?

[Guest]

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?

 

[Guest]

There is no specific button for that command, but you can either add the
Cells... button or create a simple that can be attached to a custom button.

The long text issue, I believe, is normally considered a feature that allows
longer labels to be fully displayed/printed without widening the column. The
way to deactivate it is to turn Wrap ON in Format>Cells>Alignment. Note that
the "overflowing" to adjacent cells is only allowed if those cells have no
content of their own. |:>)

 

[Gord Dibben]

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

 

[Guest]

Alt+Enter while you are still in edit mode in the cell does the trick.