XL2003: why does word wrap stop wrapping?

One of the problems I've run into since I've been using v2003 is that
after a while, data in a cell stops wrapping even when text wrap is
on.  At that point, I have to manually go in an add the line breaks.

This seems to happen to cells with a lot of information in them.

Was wondering why this was the case.  In XL2K, we had the 255
character limit, of course, but in 2003 we can enter so much more
information.  But then the word wrap problem begins.

Is there a way around this problem?

thx  :oD

0
8/28/2008 6:31:53 PM
excel 39879 articles. 2 followers. Follow

4 Replies
414 Views

Similar Articles

[PageSpeed] 26

Yes, you need to add Alt-Enters every 100 characters or so.

StargateFanNotAtHome wrote:
> One of the problems I've run into since I've been using v2003 is that
> after a while, data in a cell stops wrapping even when text wrap is
> on.  At that point, I have to manually go in an add the line breaks.
> 
> This seems to happen to cells with a lot of information in them.
> 
> Was wondering why this was the case.  In XL2K, we had the 255
> character limit, of course, but in 2003 we can enter so much more
> information.  But then the word wrap problem begins.
> 
> Is there a way around this problem?
> 
> thx  :oD
> 

0
birelan (531)
8/28/2008 7:21:11 PM
1024 characters is the display limit by default..........you can enter 32767
characters in a cell but only 1024 will display or print.

No way to increase that limit other than to add the linefeed(Alt + ENTER)
every 100 characters.


Gord Dibben  MS Excel MVP

On Thu, 28 Aug 2008 14:31:53 -0400, StargateFanNotAtHome
<IDon'tAcceptSpam@NoJunkMail.com> wrote:

>One of the problems I've run into since I've been using v2003 is that
>after a while, data in a cell stops wrapping even when text wrap is
>on.  At that point, I have to manually go in an add the line breaks.
>
>This seems to happen to cells with a lot of information in them.
>
>Was wondering why this was the case.  In XL2K, we had the 255
>character limit, of course, but in 2003 we can enter so much more
>information.  But then the word wrap problem begins.
>
>Is there a way around this problem?
>
>thx  :oD

0
Gord
8/28/2008 7:41:57 PM
On Thu, 28 Aug 2008 12:41:57 -0700, Gord Dibben <gorddibbATshawDOTca>
wrote:

>1024 characters is the display limit by default..........you can enter 32767
>characters in a cell but only 1024 will display or print.
>
>No way to increase that limit other than to add the linefeed(Alt + ENTER)
>every 100 characters.


Thanks!  Good to know this.  This information hadn't come my way and
I'm new to XL2007.

Do any of you use a macro to do the splitting up of lines, by any
chance?  Or is there any way to do this programmatically, in other
words?

Thx.  :oD


>Gord Dibben  MS Excel MVP
>
>On Thu, 28 Aug 2008 14:31:53 -0400, StargateFanNotAtHome
><IDon'tAcceptSpam@NoJunkMail.com> wrote:
>
>>One of the problems I've run into since I've been using v2003 is that
>>after a while, data in a cell stops wrapping even when text wrap is
>>on.  At that point, I have to manually go in an add the line breaks.
>>
>>This seems to happen to cells with a lot of information in them.
>>
>>Was wondering why this was the case.  In XL2K, we had the 255
>>character limit, of course, but in 2003 we can enter so much more
>>information.  But then the word wrap problem begins.
>>
>>Is there a way around this problem?
>>
>>thx  :oD

0
9/2/2008 11:09:56 PM
You were speaking of 2003 version in your original post to which I replied.

Did you just recently install 2007 version?

I don't know if the limits have changed in 2007.

Wait for a 2007 user to drop in.


Gord

On Tue, 02 Sep 2008 19:09:56 -0400, StargateFanNotAtHome
<IDon'tAcceptSpam@NoJunkMail.com> wrote:

>On Thu, 28 Aug 2008 12:41:57 -0700, Gord Dibben <gorddibbATshawDOTca>
>wrote:
>
>>1024 characters is the display limit by default..........you can enter 32767
>>characters in a cell but only 1024 will display or print.
>>
>>No way to increase that limit other than to add the linefeed(Alt + ENTER)
>>every 100 characters.
>
>
>Thanks!  Good to know this.  This information hadn't come my way and
>I'm new to XL2007.
>
>Do any of you use a macro to do the splitting up of lines, by any
>chance?  Or is there any way to do this programmatically, in other
>words?
>
>Thx.  :oD
>
>
>>Gord Dibben  MS Excel MVP
>>
>>On Thu, 28 Aug 2008 14:31:53 -0400, StargateFanNotAtHome
>><IDon'tAcceptSpam@NoJunkMail.com> wrote:
>>
>>>One of the problems I've run into since I've been using v2003 is that
>>>after a while, data in a cell stops wrapping even when text wrap is
>>>on.  At that point, I have to manually go in an add the line breaks.
>>>
>>>This seems to happen to cells with a lot of information in them.
>>>
>>>Was wondering why this was the case.  In XL2K, we had the 255
>>>character limit, of course, but in 2003 we can enter so much more
>>>information.  But then the word wrap problem begins.
>>>
>>>Is there a way around this problem?
>>>
>>>thx  :oD

0
Gord
9/2/2008 11:38:19 PM
Reply:

Similar Artilces:

Wrap text on Column "Task name/Description" of Timesheet View page
Dear all, Is there any way to wrap text on Column "Task name/Description" of Timesheet View page? Is it possible through javascript or through the relative aspx page? I'll appreciate any help on that. Kind regards, Konstantinos Christodoulakis Senior Project Manager Hi again, unfortunately that is natively not possible in 2007. You may be able to develop this functionality and may want to ask the question at the project developer user forum. thanks Marc [MVP] "Konstantinos Christodoulakis" <KonstantinosChristodoulakis@discussions.microso...

When I start Word
I am using office 2007 on my Vista Dell computer. When I go to MS Word and start it, computer asks if I want to start this program and then it opens like it is opening in SAFE Mode. -- Chuck Poole In the absence of the exact wording of the message, take a look at http://www.gmayor.com/what_to_do_when_word_crashes.htm then http://word.mvps.org/FAQs/AppErrors/ProblemsStartingWord.htm. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP...

Word 2003 Can't Save File After Update To Windows 7
This a new entry for a previously reported problem. The original problem is that I am unable to save Word 2003 files in normal mode. The message indicates that I do not have enough HDD or RAM space. Neither case is true. I can save files by running Word in XP compatibility mode but I then can't open a file from outside Word by clicking on it. I get a message that says 'Unable to send command to the program.' Everything works ok in Safe Mode. The question arose about a NAV plug-in. I have temporarily removed Norton AntiVirus completely, no help As far a...

How do I change the words that pop up when curser is over pic?
I am using Publisher and when I am sending the document words are poping up over different sections and pictures when the curser is over it. How can I change the hidden words and or remove them? Thanks for your help Is the publication a Web page? -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx "Avi" <Avi@discussions.microsoft.com> wrote in message news:A7A43858-44DB-420B-97C7-EC87213F7AC3@microsoft.com... >I am using Publisher and when I am sending...

Word Templates 03-08-10
I have a document with its template as my own custom template. If I make changes to the styles how do I save them as permanent changes to my undelying custom template? -- dbuchanan Make sure a document based on your custom template is the active document. In the Modify Style dialog box, make the desired changes and then select "New documents based on this template" (Word 2007) or "Add to template" (Word 97-2003). When you are prompted to save your template, choose to do so. -- Stefan Blom Microsoft Word MVP "dbuchanan" <dbuchanan@n...

Currency to words?
Hello, I once again have a problem that I need help with. I have designed a payroll program in Excel 2000. So far it works great. I am trying something new with it. On Sheet1 I have the information. I have designed pay stubs on sheet 2 (Emp Stubs). I have the info from sheet 1 carried over to the Emp Stubs sheet through the use of the following formulas: =SUM(Sheet1!H9) I know this is a lot of work when I could probably just buy Quicken, but I really need to keep using this method. NOW MY PROBLEM. I need to be able to take currency, for example $717.13 and convert it over to words, for ...

Words and dates...
Someone very helpful helped me with a formula and hope maybe they can help me once agian. they gave me the following formula, which searched for text within a column. What do I need to do to adjust that to choose specific text within certain dates... =COUNTIF(C:C,"RXL") it works great... but I came up with the problem of needing only the Rxl's between certain dates. This formula calculates them all. Let's assume that the dates are in column B. Try this: =SUMPRODUCT(--(B1:B100>DATE(2007,1,1)),--(B1:B100<DATE(2008,1,1)),--(ISNUMBER(SEARCH("RXL",C1:C...

Change date format for existing sheet? (XL2K+XL2003)
Don't know if this will be the right group for this. I have some spreadsheets that I must chart but the date formats are not the best. The sheet has the months like this: April 1 to 30 May 1 to 31 June 1 to 30 July 1 to 31 August 1 to 31 September1 to 30 October 1 to 31 November1 to 30 December 1 to 31 January 1 to 31 February 1 to 28 March 1 to 31 When I will need the smallest yet most complete info so that if I could convert the above quickly to format below, that would be best: Apr.01-30.2007 May.01-31.2007 Jun.01-30.2007 Jul.01-31.2007 Aug.01-31.2007 Sep.01-30.2007 Oct.01-31.2007 No...

my word document xxx.doc
changed to xxx.dat when sending as attachments. What could be causing this problem? Everything has been working fine for the last week or so until yesterday. Nothing has changed ...

Possible to link Excel cells to text box in Word using Word's text formatting?
Hi everyone. Here is one of those "is this possible" type situations, which if possible, would make my Augusts less stressful each year. Each August I'm in charge of putting together our annual statistics and producing maps of the state to show activity in each county. Initially my maps were Word documents with individual text boxes for each #. I still have that version saved, but recently I've converted it to a pdf document to make changing the numbers a lot easier (although not being able to add lines of text is a hindrance sometimes). What I'd love to be able to do i...

Outlook 2003 stops Send/Recv on Login Failure
Hello everyone, This has been a nagging issue with me for years and I can't find the settings anywhere to fix it. At my office I use Outlook to service 5 email accounts. Almost every morning I come in and it is stuck on prompting me for a login. My login ID/PWDs have not changed in years. They work most of the time, but ususally overnight at least one account gets stuck, and it stops the entire process from finishing. I usually just cancel the send/receive, and then everything works fine for the rest of the day...without my changing any information. No, we don't use Exchange, ju...

Word for mac wont open
I get a message that word has quit unexpectedly and click reopen. Then I click reopen then the same message pops back up and word doesn't open. The message report below. Process: Microsoft Word [1705] Path: /Users/mo/Desktop/Microsoft Word.app/Contents/MacOS/Microsoft Word Identifier: com.microsoft.Word Version: ??? (???) Build Info: Unknown-91001~0 Code Type: X86 (Native) Parent Process: launchd [91] Date/Time: 2010-02-13 21:42:54.179 -0800 OS Version: Mac OS X 10.6.2 (10C540) Report Version: 6 Interval Since...

how do insert a Word file into a powerpoint slide presentation
I need to have several word text files in among numerous Photoshop slides for my presentation. I have the photo slides OK. How do I insert the text slides? Thanks. Hi Lawrence, if you can not easily/ clearly represent the word information by copying and pasting the text to a powerpoint slide i would suggest adding a hyperlink to the external word doc. make sure you collate the word documents and powerpoint file in a folder prior to setting the hyperlinks. Insert/ Hyperlink/ Existing File. -- Emma Bannister PowerPoint Specialist www.presentationstudio.com "Lawren...

Text does not Wrap, but Wrap Text is Selected
When I have a large group of text in a cell sometimes the text towards the end will not wrap. This occures even if I increase the row height. Wrap text is checked in Format Cells. How do i correct this? I bet that this cell has a lot of characters in it. Sometimes if you add a few alt-enters (line breaks within the cell), xl will act nicer. R Robertson wrote: > > When I have a large group of text in a cell sometimes the > text towards the end will not wrap. This occures even if I > increase the row height. > > Wrap text is checked in Format Cells. > > How d...

I want to use in word an equation in professional form.
I want to use an equation in professional form.Please I would like to teel me how I can do this in word 2003 thank you. On Tue, 4 Dec 2007 16:24:03 -0800, lina wrote: > I want to use an equation in professional form.Please I would like to teel me > how I can do this in word 2003 > thank you. You have posted this message to the wrong newsgroup. The access in this groups name refers to Microsoft Access, a database program. Please repost to the correct newsgroup for whatever Office program you are using. I would suggest you include your Windows and Office version number in the messa...

Word Automation Data Sources
Hi, My customer wants me to generate an invoice from data contained in MS Access. He has a Microsoft Word - based invoice that he currently uses and wants the new system to use the same document. So I intend to use Word Automation and MailMerge to meet the requirement. Some of the information on the invoice is name, address, city, state, zip - one record per invoice, no problem. But he also has a detailed section of the invoice that will contain multiple line items. So there will be multiple records per invoice for that part. Question: Can one Word document hav...

Importing into MS Word
Some help for a novice! How can I import a page of a Publisher (2003) document into a MS Word (2003) document? I have access to Acrobat 5.0, if that's relevant. Thanks for any help. Jim Jones Botswana Jim Jones <JimJones@discussions.microsoft.com> was very recently heard to utter: > How can I import a page of a Publisher (2003) document into a MS Word > (2003) document? Can you tell us why you want to do this? We might be able to provide appropriate suggestions if you do > I have access to Acrobat 5.0, if that's relevant. I take it you do mean the full versio...

Insert webpage into word
Is is possible for Word to automatically insert a webpage into word? I am putting together a "daily information" document for the crews in the field, and would like to send them this document whereas the weather section is automatically updated with the latest forecast. I suppose I could just use a hyperlink, but what fun is that? Thanks, Ryan ...

List with Hyperlinks
HI, I have a large list of names and telephone numbers which is used to populate cells in a multisheet workbook. I have this list on a worksheet called 'List' along with many other such lists all ranges are allocated a name for easy insertion into the main sheets.. In the sheet 'List' I can turn the name and telephone number into a hyperlink to call a mailto:persons.name@etc.... however when I select this person from the dropdown list in the other sheets it no longer acts as a hyperlink is there a way I can get this functionality? -- Steve Those who agree with us ma...

How do I stop excel from changing fraction to lowest denominator?
I need to have tire measurements in a spreadsheet and they are written in "thirtyseconds"... ie: 10/32 8/32 22/32 16/32 however, excel changes my entries to the lowest common denominator.. ie: 5/16 1/4 11/16 1/2 I need to have it displayed as I entered it... how do I stop this? I created the ss from scratch, so excel is doing this on it's own... :( Help? Maybe you could use your own custom number format: # 0/32 Select the range format|cells|number tab|custom category (xl2003 menus) You'll be able to type in 1 16/32 and see that in the cell. But you'll see ...

Word will not allow me to edit Callouts in the Format AutoShape box.
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC In order to edit callouts I have to click on the 'Format Callout' button in Format AutoShape,Text box. The problem is it is not allowing me to do this! It is not highlighted, although 'Convert to Frame' is. Could anyone tell me what I am doing wrong? The 'Format Callout' button only applies to Line Callout AutoShapes, so unless you've selected one of them the button will be dimmed. It does not apply to Rectangle, Rounded Rectangle, Oval or Cloud callout shapes. You haven't indi...

Opening XLS with XL2003, not XL2007
I have both Excel 2003 and Excel 2007 installed on the same machine. Until today, I could doubleclick on any .XLS file and it would automatically open in the old Excel. Now, however, it opens in the new Excel in compatibility mode. Even if I go to change the file association in Windows shell, Excel 2007 still keeps taking over. As far as I know, nothing has changed on my system. Anybody know how I can get Windows to always use the old version for the .xls files? I don't know why it keeps changing for you, but this may work to change it back: Close Excel and Windows Start Button|Run...

I have a document in Word 2007 that will not keep the highlights.
Every time I highlight certain sentences in my document and save those highlights, it saves and I can close the document...then open it again with the saved info in place. Here's the rub, when I close it and come back to it after a day or so the saved highlights are gone. Help! ...

radio buttons in XL2003
I need to have 2 columns of radio buttons on a worksheet. If the left button on row 10 is selected, then the value in cell F10 should be 5, if the right button at row 10 is selected, the value in F10 should be zero. If the left button at row 11 is selected, the value in F11 will be 5. If the right button in row 11 is selected, the value in F11 should be zero. On each row from 10 - 21 [12 rows] one button will be selected and the appropriate value [0 or 5] should appear in cells F10:F21. My problem is, when i create multiple button, they all reference the same one cell. How can i create multpl...

User Interface for Word
Is it possible to design a user interface that runs on top of Word to generate documents? There are numerous, expensive Electronic Medical Record (EMR)applications that allow you to select items on a user interface that generate patient notes and reports. They don't provide a great deal of flexibility. I would like to design my own. Does Word have this capability? If not, is there another application that does? I wouldn't try to design some kind of user interface on top of Word. Although it might be possible, there are better ways of handling this. Why not let your...