Excel - How to increase # of characters displayed in cell

  • Thread starter Thread starter JTD
  • Start date Start date
J

JTD

Excel allows 32,767 characters in a single cell but it only displays th
first 1,024. Is there a way around this? If so, please explain i
laymans terms. Thank you very much for any help you can provide
 
You can't break the 32k limit, but you can see more characters in the cell if
you pepper (a layman's term <bg>) your text with a bunch of alt-enters where you
want to see line breaks within the cell.

Hit and hold the alt and then hit enter at various spots.
 
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

Increasing # of Characters to display from a cell 6
Test For 1,024 Characters 5
Spell check / character cell limit 2
limit on cell contents 1
How do I display more than 1,024 characters in Excel 2003? 2
Why can't I get more than 255 characters in one cell in Excel 07? 1
Problem printing a large excel cell 5
Solve the Mystery of the Truncating Text 3

Back
Top