|  | XL2003: why does word wrap stop wrapping? | | |
| | | StargateFanNotAtHome |  |
|  Posted: Thu Aug 28, 2008 4:31 pm Post subject: 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  D |
| |
| | | Bob I | |
| | Posted: Thu Aug 28, 2008 5:21 pm Post subject: Re: XL2003: why does word wrap stop wrapping? | |
Yes, you need to add Alt-Enters every 100 characters or so.
StargateFanNotAtHome wrote:
| Quote: | 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 D
|
|
| |
| | | Gord Dibben | |
| | Posted: Thu Aug 28, 2008 5:41 pm Post subject: Re: XL2003: why does word wrap stop wrapping? | |
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:
| Quote: | 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 D |
|
| |
| | | StargateFanNotAtHome | |
| | Posted: Tue Sep 02, 2008 9:09 pm Post subject: Re: XL2003: why does word wrap stop wrapping? | |
| |  | |
On Thu, 28 Aug 2008 12:41:57 -0700, Gord Dibben <gorddibbATshawDOTca>
wrote:
| Quote: | 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. D
| Quote: | 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 D |
|
| |
| | | Gord Dibben | |
| | Posted: Tue Sep 02, 2008 9:38 pm Post subject: Re: XL2003: why does word wrap stop wrapping? | |
| | | |
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:
| Quote: | 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. D
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 D |
|
| |
|
|
