Cell height cannot be resized via GUI.
following Macro must be used
Sub SetRowHeightInCentimeters().
Dim cm As Single.
Cm = Application.InputBox("Enter Row Height in Centimeters", _.
"Row Height (cm)", Type:=1).
If cm Then.
Selection.RowHeight = Application.CentimetersToPoints(cm).
End If.
End Sub.
Updated:
2026 Aug 19
