Word Wrap in a Cell

  • Thread starter Thread starter Sheep
  • Start date Start date
S

Sheep

I have some text in which I have selected format cells, alignment, wor
wrap.
The text will wrap but stops after so many words are entered. The po
up of the cell shows all the text in the cell but when you look at th
cell it does not display
all the text.
Any suggestions appreciated
 
Sheep

How much text are you entering in the cell?

You can enter 32,767 characters in a cell.

BUT......By default Excel will show or print only 1024 of those characters.

You can increase this 1024 limit by adding a few ALT + ENTERs at appropriate
spots throughtout.

Gord Dibben Excel MVP
 
Have you adjusted the row height to accommodate the wrap?

Instead of automatic wrapping you might try breaking the line with Alt-Enter.
Not as flexible but maybe a work-around.

rs
 
Is it that the row height needs changing?

Format / Row/ AutoFit

--

Regards

Bill Ridgeway
Computer Solutions
 
Back
Top