Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 23rd 05, 10:05 PM
JAM_Analyst
 
Posts: n/a
Default Does Excel 2003 have a shortcut command to wrap text in a cell?

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?

  #2   Report Post  
Old February 23rd 05, 10:47 PM
CyberTaz
 
Posts: n/a
Default

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?

  #3   Report Post  
Old February 23rd 05, 11:27 PM
Gord Dibben
 
Posts: n/a
Default

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?


  #4   Report Post  
Old June 12th 07, 06:01 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2007
Posts: 1
Default Does Excel 2003 have a shortcut command to wrap text in a cell?

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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening DBF files with Excel 2003 via Windows Explorer ? David Purdy Setting up and Configuration of Excel 2 May 3rd 06 09:21 PM
how can I get odbc plugin for Excel 2003 ? Herve Brelay Excel Discussion (Misc queries) 1 January 30th 05 01:26 AM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 08:27 PM
Are there any significant differences in Excel 2003 from Excel 20. techtrainerey Excel Discussion (Misc queries) 1 January 18th 05 08:03 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 09:05 PM


All times are GMT +1. The time now is 08:13 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017