length of character data

S

Saravanan

If I keep typing all characters in a cell, how many
characters can a cell contain ?
In other words , a line in a cell can contain how many
characters ?

Thanks.

==
 
F

Frank Kabel

Hi
1024 characters is the maximum for a cell to display. If you want to extend
this limit you may enter manual linebreaks with ALT+ENTER
 
G

Gord Dibben

32,767 is the number of characters that can be entered in a cell.

However......only 1024 of these will display.

The maximum width of a column is 255 characters, so word wrap must be enabled
to see the full 1024.

See Frank's post for a partial work-around using ALT + ENTER.

Gord Dibben Excel MVP
 
Top