Excel Cell Text Cutting Off

[Guest]

I have a large amount of text that I am inputting into a merged cell. When I
am editing the text, all the content displays. When I click outside the cell,
only a portion of the text displays. How can I get the entire text to display
in the cell?

 

[Gord Dibben]

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.

BTW...............merging multiple cells does not increase this limit.

You still have one cell.


Gord Dibben MS Excel MVP

 

[Guest]

Thank you, Gord - when I counted the characters, it totaled 1683 with spaces
and 1431 without spaces. From the information you provided, my text should
display. I played with the table height, formatting the cells, I am missing
something. I will probably slap my forehead when I hear or figure it out. Do
you have any suggestions?

 

[Dave Peterson]

About 1024 includes spaces. And both 1683 and 1431 are larger than 1024.

You'll want to add those alt-enters every 80-100 characters to see more than
1024 (about) characters.

 

[Guest]

Thank you Dave and Gordon - egg on my face. Although I read the message, I
still forgot about the display factor. I will put in the alt-enters.

Thanks for being understanding and still willing to help out someone who
could not 'see the forest through the trees'.

Happy Friday!

 

[Guest]

Hi,

If you enter the text in a single cell, the text wrap checkbox, in the Text
Control section of the Alignment tab automatically gets selected and the text
wraps completely within the cell. But if you merge one or more cell using the
Text Wrap under the Text Control section in the Alignment tab, you must
manually adjust the Width and length of the cell using the mouse.

Challa Prabhu