Text String in Excel

J

JBH

What is the default text string size that can be entered into a cell and can
I increase it?
 
D

Dave Peterson

The default???

The maximum in xl97+, is 32,767 characters. If you don't do anything special,
you'll be able to see about 1000 characters.

But if you add alt-enters to force new lines within the cell (every 80-100
characters), you'll be able to see lots more.
 
Top