Cell does not expand to fit text

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.
 
G

Gord Dibben

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
Cell not expending automatically. 8
Automate row height to fit text 3
Making row automatically expand as text is typed. 2
Auto fit row height for one column 3

Top