Text stops wrapping in cell. Tried AutoFit.

G

Guest

Entered several lines of text in cell using "wrap text". No problem. After
about 20 lines newly entered text would not wrap. Used AutoFit and there was
no change. Manually expanded the cell and no change. Does anyone know why
text will wrap for 15 + lines then all subsequent text will not wrap? HELP!
 
G

Gord Dibben

Excel will allow 32767 characters to be entered in a cell.

But.....only 1024 of these will be visible or can be printed.

Is this your problem?

You can extend this 1024 limit by using a smaller font or adding an Alt + Enter
every 80-100 characters.


Gord Dibben MS Excel MVP
 

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

Wrap text in cell 1
Why wont 'autofit' and 'wrap text' remain in tact? 3
Why does my text in a cell with wrap text and auto height get cut 4
Wrapping Text in Merged Cells 4
Auto fit and text wrapping problem 1
Text Wrapping 2
Link text box to a cell 1
Text stops wrapping within the cell 2

Top