Cell does not expand to fit text

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

In Excel 2003, I've got some text formatted with "Wrap text" format. I
normally expect a cell to expand to show all the text in the cell, but Excel
only shows part of the text. When I double-click on the row separator, I
expect Excel to expand the row height to show the full text, but Excel does
not expand it sufficiently. (It stops at Row Height = 240.) I can manually
expand the row height and Excel shows a couple more lines, but then it starts
leaving blank space at the bottom, and some of the text is still not shown.

Any suggestions?

Thanks.
 
How much text?

Excel will allow 32767 characters in a cell but display only 1024.

Add an Alt + Enter linefeed every 100 chars to expand this limit.


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

Rows expand to fit text typed in? 2
Wrap Text doesn't work in Merged Cell 1
wrapping text in merged cells 2
Getting word wrap to work in a merged cell 1
Are there limits autofit row height when the cell is set to wrap t 3
What controls row expansion to show muli-line text in a word-wrap 1
expand row to fit 1
Missing text 1

Back
Top