Excel - How to increase # of characters displayed in cell

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
 
D

Dave Peterson

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.
 

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
limit on cell contents 1
Spell check / character cell limit 2
How do I display more than 1,024 characters in Excel 2003? 2
Problem printing a large excel cell 5
Solve the Mystery of the Truncating Text 3
Beyond 1024 cell content limit 6

Top