Expanding cells

[Jim Varner]

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?

 

[Gord Dibben]

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

 

[Jim Varner]

Thank you, much

Jim Varner

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