Cell data not visible (I have wrapped text & resized)

[Toni D]

Even though I have resized the cells and wrapped text, the total contents of
cells with a lot of data in them are not visible in the worksheet. The full
cell contents are only visible in the formula bar.

[JE McGimpsey]

XL has a limit of 1024 characters that can be displayed or printed in a
cell, even though the max length of a cell is 32767 chars.

One workaround is to manually enter a linefeed (ALT-ENTER) at least
every 1024 chars.


In article <[email protected]>,
Toni D <Toni [email protected]> wrote:

> Even though I have resized the cells and wrapped text, the total contents of
> cells with a lot of data in them are not visible in the worksheet. The full
> cell contents are only visible in the formula bar.

[Toni D]

Thanks JE McGimpsey.

"JE McGimpsey" wrote:

> XL has a limit of 1024 characters that can be displayed or printed in a
> cell, even though the max length of a cell is 32767 chars.
>
> One workaround is to manually enter a linefeed (ALT-ENTER) at least
> every 1024 chars.
>
>
> In article <[email protected]>,
> Toni D <Toni [email protected]> wrote:
>
> > Even though I have resized the cells and wrapped text, the total contents of
> > cells with a lot of data in them are not visible in the worksheet. The full
> > cell contents are only visible in the formula bar.
>