All Text Does Not Appear in Some Cells

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

All the text does not appear in a few cells. All the text does appear in the
tool bar's formula window.

"Wrap text" is clicked on.

I unsuccessfully tried turning Autofit on and off and tried switching
between General and Text. No change - all the text still didn't appear.

The cells in question have more text than the other cells.
 
Excel will allow 32767 characters in a cell.

However, only 1024 of these will be visible in that cell, although you see
all of them in the formula bar.

Add an Alt + Enter every 100 or so characters to increase this limit.


Gord Dibben MS Excel MVP
 
Back
Top