Why do not all words show up in an excel cell?

G

Guest

When I am wrapping text in a cell and get a large amount of characters, it
stops displaying them in the workbook, though it is visible in the fx bar.

I have heard that there is a max # of characters, but I don't think I am
anywhere near the number. Also, I have confirmed that the cells are set to
general formatting, but still no luck.

Any ideas?
 
G

Gord Dibben

Jerry

You can enter 32,767 characters in a cell.

Unfortunately only about 1024 will show or print.

If you add an Alt + Enter every 100 characters you can increase this limit.


Gord Dibben MS Excel MVP
 

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

How do I show all words in a cell? 4
Set default cell format while retaining overrides 3
How do I view ALL Text in a cell 3
# of allowable characters in Excel 2003 cell 4
Excel - How can I keep all text in one cell when it's extremely lo 1
When sharing, can I force an Excel document to open in a certain view? 0
Text in merged cells - not printing all words within the cell 1
Why doesn't a ' symbol show up at start of Excel cell 1

Top