View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Cell does not expand to fit text

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

On Wed, 10 Sep 2008 13:55:01 -0700, Eric
wrote:

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.