In older versions of Excel, you used to be able to select a bunch of rows, right click on a row, and select Autofit. It would autofit all rows’ height. I can’t find this in recent versions of Excel. There must be a better way, but here’s my work-around.

Create a function that looks like this:

Public Sub Autofit_Selection()
    Dim I As Long
    Dim j As Long
    Dim s As String

    I = Selection.Row
    j = I + Selection.Rows.Count - 1
    s = CStr(I) + ":" + CStr(j)
End Sub

Select the rows you want to auto-fit. Then run the macro.