Adjust the text size automatically

Occasional Visitor

I need the box to adjust (width and height) the text size. If I change the width, the height will adjust automatically. No manual work needs to do.



1 Reply


Change the column width and row height

Open Excel and select the cell whose height is to be adjusted.

You can also select the entire line or the entire content of the document using (Ctrl) + (A).

Then click Home > Format > AutoFit Row Height.


...or with VBA Code


Sub TextinCell()


End Sub