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?

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 FormatCellsAlignment. Note that
the "overflowing" to adjacent cells is only allowed if those cells have no
content of their own. |:)

"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?

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?

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



"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?