If you've ever set the rowheight manually, then excel won't autofit that row
when the text changes. If you autofit the row, then excel will autofit it, too.

And when you have lots of text in a cell, you may have to enter alt-enters
(every 80-100 characters) to see more than the documented 1024 characters.



Stilson wrote:

I'm using Excel 2000 and XP Pro. I'm formatting a text page whereby users
can input text into a column and I want the text to wrap so that whatever
the length of their text we see it all. On a default page it works fine.
However I tinkered with the row height for font purposes and now the text
will wrap but the row won't expand to fit the whole text. How do I reset
the row/sheet or whatever to get the display I want? Thanks

--
Stilson Snow

--

Dave Peterson