Prev: Selecting Multiple Shapes and Lines
Next: Duplicate Rows
From: CeeTee9 on 19 Feb 2010 14:29
I have the same problem in Excel 2007 and the data in the cell is < 30
characters. I simply cannot get excel to wrap the text--and, yes, I have the
"wrap text" box checked. The only thing I've found that enables me to see
the bulk of the text is to increase the row height--which is unacceptable.

"Shane Devenshire" wrote:

> Hi,
>
> the answer is version dependent:
>
> 2003:
> Cells can contain 1024 characters in a formula
> Cells can contain 32,767 text characters but only the first 1023 will be
> visible (unless you use Alt Enter to force line breaks)
>
> 2007:
> Cells can contain 8192 characters in formulas
> Cells can contain 32,767 text characters in cells and all can be seen and
> printed without needing to use Alt Enter.
> --
> If this helps, please click the Yes button.
>
> Cheers,
> Shane Devenshire
>
>
> "Steve P" wrote:
>
> > I have a data extract taken from a Share Point list that has larger memo-type
> > data in it. I am trying to format some of this data in Excel for a report we
> > are creating and can't get the raw-text-data to wrap correctly in the cell.
> >
> > The data has not been truncated, as all of it is in the cell...it simply
> > won't wrap to the next line like it should, even with the "Wrap Text"
> > formatting parameter activated. It looks as though the text string just
> > continues into the next, right-most cell and isn't completely visable.
> >
> > Please advise...
From: Gord Dibben on 19 Feb 2010 16:14
Have you tried setting the row to Autofit?

Wraptext means nothing if rowheight is manually set.


Gord Dibben MS Excel MVP


On Fri, 19 Feb 2010 11:29:02 -0800, CeeTee9
<CeeTee9(a)discussions.microsoft.com> wrote:

>I have the same problem in Excel 2007 and the data in the cell is < 30
>characters. I simply cannot get excel to wrap the text--and, yes, I have the
>"wrap text" box checked. The only thing I've found that enables me to see
>the bulk of the text is to increase the row height--which is unacceptable.
>
>"Shane Devenshire" wrote:
>
>> Hi,
>>
>> the answer is version dependent:
>>
>> 2003:
>> Cells can contain 1024 characters in a formula
>> Cells can contain 32,767 text characters but only the first 1023 will be
>> visible (unless you use Alt Enter to force line breaks)
>>
>> 2007:
>> Cells can contain 8192 characters in formulas
>> Cells can contain 32,767 text characters in cells and all can be seen and
>> printed without needing to use Alt Enter.
>> --
>> If this helps, please click the Yes button.
>>
>> Cheers,
>> Shane Devenshire
>>
>>
>> "Steve P" wrote:
>>
>> > I have a data extract taken from a Share Point list that has larger memo-type
>> > data in it. I am trying to format some of this data in Excel for a report we
>> > are creating and can't get the raw-text-data to wrap correctly in the cell.
>> >
>> > The data has not been truncated, as all of it is in the cell...it simply
>> > won't wrap to the next line like it should, even with the "Wrap Text"
>> > formatting parameter activated. It looks as though the text string just
>> > continues into the next, right-most cell and isn't completely visable.
>> >
>> > Please advise...

 | 
Pages: 1
Prev: Selecting Multiple Shapes and Lines
Next: Duplicate Rows