Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Expanding Capabilities of Wrap Text in a cell

How can wrap text be used on a large amount of text in a cell? I can expand
the cell box for additional text with Alt+Enter, but wrap text seems to work
only up to a limited amount of characters within a cell and then it stops.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default Expanding Capabilities of Wrap Text in a cell

Hi,

I think the problem is not the wrap text only works up to a certain number
of characters, Excel only displays a certain number of characters in a cell,
and you have found the way to beat that limit - Alt+Enter.

In Excel 2003:
Only 1,024 display in a cell; all 32,767 display in the formula bar
In 2007 you can see and display 32768 characters in a cell

If this is helpful, please click the Yes button

Cheers,
Shane Devenshire

"EvergreenHawk" wrote:

How can wrap text be used on a large amount of text in a cell? I can expand
the cell box for additional text with Alt+Enter, but wrap text seems to work
only up to a limited amount of characters within a cell and then it stops.

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
Can not see text in Excel when cell format is set to wrap text Mark New Users to Excel 1 May 29th 07 02:07 PM
How do I view all text in a merged cell? Wrap text is activated. susjorg Excel Discussion (Misc queries) 1 January 23rd 07 07:34 PM
Why won't text in cell wrap. Cell format set to wrap. DRB Excel Discussion (Misc queries) 2 September 28th 06 08:27 PM
Text not continuing to wrap for large block of text in Excel cell Mandra Charts and Charting in Excel 1 May 15th 06 07:13 PM
Row height not expanding w/ word wrap JHersko Excel Discussion (Misc queries) 2 April 3rd 06 10:05 PM


All times are GMT +1. The time now is 04:39 PM.

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

About Us

"It's about Microsoft Excel"