Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell does not expand to fit text
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows expand to fit text typed in? | Excel Discussion (Misc queries) | |||
how do I make the cell expand to fit my text as I type? | New Users to Excel | |||
How do I expand the amount of text I can put in a cell? | Excel Discussion (Misc queries) | |||
How do I automatically expand a merged cell with wrapped text? | Excel Discussion (Misc queries) | |||
Excel merged cell - can it automatically expand as text is typed? | New Users to Excel |