Word Wrap in a Cell

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
 
G

Gord Dibben

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
 
T

TCEBob

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
 
B

Bill Ridgeway

Is it that the row height needs changing?

Format / Row/ AutoFit

--

Regards

Bill Ridgeway
Computer Solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Wrap in Cell Stops??? 3
How to Wrap Text 2
wrap command shortcut 4
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2
Wrap Text in Merged Cell - How? 8
Word wrap in excel? 2
hanging indent in a cell 2
No word wrap 7

Top