Format>Cells>Alignment. Check "wrap text" and Format>Row>Autofit.
OR to go the other way, Format>Column>Autofit Selection
Note: the entire row or column will expand, not just the one cell.
Gord Dibben MS Excel MVP
>Is there a way to have a cell expand automatically as text is added so the
>entire text shows without having to manually adjust cell size?
Jim Varner - 24 Feb 2008 00:50 GMT
Thank you, much
Jim Varner
> Format>Cells>Alignment. Check "wrap text" and Format>Row>Autofit.
>
[quoted text clipped - 6 lines]
>>Is there a way to have a cell expand automatically as text is added so the
>>entire text shows without having to manually adjust cell size?