Merged Cell not showing all data

[Dustin]

I have a form that has a large number of cells merged,
used as a comment field. When a large comment is put in
the cell all data will show in the toolbar, but it will
not show or print in the cell.

DOes anyone have any ides what is happening?

Thank you.

 

[RSnyder]

If it is showing nothing at all in the cell then check to
make sure the cell isn't formatted as hidden. If its
showing just the first portion then widen the column or
apply word wrap. There is still a limit to how long a
label you can have.

 

[Gord Dibben]

From Help>Specifications

Excel will allow 32,767 characters in a cell. Only 1024 will be visible or
print.

You can force some more by hitting ALT + ENTER key after 1000 or so.

Gord Dibben Excel MVP - XL97 SR2 & XL2002