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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data labels on charts 1
CSV->Excel Data Problem 1
some text shows in merged cells but not all 2
word wrapped text does not completely display 3
Cell not calculating after importing data 2
cell shows all the data, click out of it, end of data disappears 1
Expanding Capabilities of Wrap Text in a cell 1
Cells not showing all the text 3

Back
Top