Jun 16 2022 08:39 PM
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.
Jun 19 2022 01:50 AM
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()
Columns("A:Z").EntireColumn.AutoFit
ActiveSheet.Rows.AutoFit
End Sub