The default is 1024 and cannot be reset but there are workarounds like adding an
Alt + Enter every 100 chars.

And formatting tricks.

See Harlan's response at this thread.

http://snipurl.com/1kqre


Gord Dibben MS Excel MVP


On Tue, 15 May 2007 12:21:02 -0700, Varne
wrote:

Gord Dibben

Hi

Cannot the default setting be reset to say 10000 characters? If so how?

Regards

Varne

"Gord Dibben" wrote:

You can enter 32767 characters in a cell but by default only 1024 of these
characters will show or print.

Merging many cells into one large cell does not make the cell characteristics
any different than a single cell. Just makes it look larger but has the same
constraints.

Find a different method like using a textbox.


Gord Dibben MS Excel MVP


On Tue, 15 May 2007 11:30:00 -0700, Varne
wrote:

Hi

First I explain below what I did;

I merged cells from a1 to e17.

Formatting : Left, Top and yes for wrapping.

Then I kept key 'i' until the cell got filled up.

The problems(2)

First when I click the merged cell I am not able to view the full cell
contents. Accidently only I was able to ascertain the characters after the
1050th character can only be viewed by going into the cell. Cannot I change
this?

The other problem is just like in this message box I want to move onto the
next lines in the merged cell by pressing enter or by pressing some other
key. I like my merged cell to behave just like ms word or this message box.

Could any one solve my problems?

Many Thanks.