Prev: vLookup and Line Breaking
Next: How do I subtract todays date from range of dates
From: HerbertB on 10 Mar 2010 14:23
It seems that wrap text and autofit row width and row height have a limit.

Any idea where to change this limit?

I have quite a large text in a cell and when I do wrap text and autofit,
then parts of the text get cut of. The text is still there, but it is not
shown in the cell and it is cut off when printing.

From: Gord Dibben on 12 Mar 2010 14:19
You can enter 32767 characters in a cell.

In Excel 2003 and earlier, only 1024 of these will be visible or printed.

I believe Excel 2007 will show 8192 characters.

If you add an Alt + Enter linefeed every 100 or so characters you can
increase this 1024 limit.


Gord Dibben MS Excel MVP

On Wed, 10 Mar 2010 11:23:03 -0800, HerbertB
<HerbertB(a)discussions.microsoft.com> wrote:

>It seems that wrap text and autofit row width and row height have a limit.
>
>Any idea where to change this limit?
>
>I have quite a large text in a cell and when I do wrap text and autofit,
>then parts of the text get cut of. The text is still there, but it is not
>shown in the cell and it is cut off when printing.
>

 | 
Pages: 1
Prev: vLookup and Line Breaking
Next: How do I subtract todays date from range of dates