Cell with large amount of data not showing all data

  • Thread starter Thread starter Brad Reichert
  • Start date Start date
B

Brad Reichert

I'm running Excel 97. I have a cell with 358 words (1928 characters with
spaces). Word wrap is on for the cell. Only part of the text is displayed
even though the cell is big enough to show everything. If I make the cell
wider (wider than a page) more of the text shows but not everything. I tried
a new worksheet with the same text and had the same problem. Is this a known
issue with excel? Is there a solution?

Thanks,

Brad
 
Left to its own devices, excel will only show about 1000 characters in a cell.

But you can add some alt-enters (to force a new line within the cell) and see
more stuff.
 
Thanks.

Dave Peterson said:
Left to its own devices, excel will only show about 1000 characters in a cell.

But you can add some alt-enters (to force a new line within the cell) and see
more stuff.
Click to expand...
 
Back
Top