P
Phil
Excel 2000 SP-3, Win 98.
I often have long text cells, with several paragraphs. At
some point, they all get the same sickness, wordwrap
doesn't work anymore. The lines that wrapped up to that
point still do. After the mystery point, the only way to
get a line break is Alt-Enter.
Mid-December 03, there was a short thread on this in
Crashesgpfs (look up "Maximum row size"). The one answer
was that there is a max row size of 409, so after 409
chars no more wordwrap. Sounds like my problem.
The workaround would be to quit the current cell at the
previous paragraph break, start a new one for the new
paragraph, and go on for another 409 chars. Since text
doesn't wrap the same on the sheet, in Print Preview and
in actual print, this means the cell change would be
marked by a large blank (or, conversely, hidden lines) in
one of the formats.
Anyone have a better explanation? A better solution?
I often have long text cells, with several paragraphs. At
some point, they all get the same sickness, wordwrap
doesn't work anymore. The lines that wrapped up to that
point still do. After the mystery point, the only way to
get a line break is Alt-Enter.
Mid-December 03, there was a short thread on this in
Crashesgpfs (look up "Maximum row size"). The one answer
was that there is a max row size of 409, so after 409
chars no more wordwrap. Sounds like my problem.
The workaround would be to quit the current cell at the
previous paragraph break, start a new one for the new
paragraph, and go on for another 409 chars. Since text
doesn't wrap the same on the sheet, in Print Preview and
in actual print, this means the cell change would be
marked by a large blank (or, conversely, hidden lines) in
one of the formats.
Anyone have a better explanation? A better solution?