cell format

L

Lisa

I have a spreadsheet that is used to track cases in a
legal clinic. One of the cells tends to get fairly large
and it seems that once you reach a certain point, you can
still add to it, but it will not display in the cell any
longer. It looks as if it stops wrapping to fit the cell.
When the cell is highlighted, you can see the entire text
in the formula bar, but it does not appear in the cell. Is
there a way to eliminate a limit on text in any given cell?
 
F

Frank Kabel

Hi
there's a limit of a max of 1204 characters per cell. You can extend
this limit if you manually insert some linebreaks with ALT+ENTER
 
D

Dave Peterson

I think Frank meant to write that there's a 32k limit on the number of
characters in a cell. But excel will only show about 1024 (not 1204) characters
without additional help from you.

If you sprinkle those alt-enters throughout your cell, you'll see lots more
characters.
 
Top