Text Not Showing in Cell

M

Mark

I'm using excel to produce reports with almost all text.
Some cells have a lot of words. Text Wrap is on. Row
Height is set to AutoFit. Most cells show up just fine.
Some have hidden words that run on under the next cell
below. I have even encountered some cells that cut off
right through the middle of the text. I can, of course,
manually change the height of each row, but this report is
over 200 lines long. Same problem happens when printed.

Please help.
 
R

Richard O. Neville

Excel is not the greatest text editor. Have you considered doing the report
in Word, using the Tables function? You could copy and paste your Excel
entries into a blank Word document, then edit so all will fit properly. Much
easier in Word than in Excel for text functions.
 
G

Gord Dibben

Mark

Excel Help on "limits" states that a cell can contain 32,767 characters.

However, only 1024 will show or be printed.

Sprinkle a few ALT + ENTER's at appropriate spots to increase this limit
somewhat.

ALT + ENTER is a carriage return.

Gord Dibben Excel MVP
 
Top