Text Truncates

  • Thread starter Thread starter John
  • Start date Start date
J

John

I'm having a problem with text truncating in cells. I've
double check and the format alignment is: Horizontal -
general, vertical - Top, and wrap text is checked. I have
tried different settings.

I also noticed if I double click on the cell it shows all
the text, but once I move focus out of the cell it
truncates the text again.

Any help would be appreciated.
 
Help/Specifications details that while cells can hold a maximum of 32767
characters, they can only display/print 1024.

You can display more if you put manual line breaks at least every 1023
characters.
 
double-click on the row border. Or Format>Row>Autofit.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
That explains it - Thanks

-----Original Message-----
Help/Specifications details that while cells can hold a maximum of 32767
characters, they can only display/print 1024.

You can display more if you put manual line breaks at least every 1023
characters.


.
Click to expand...
 
Back
Top