Format row height "auto, but at least ..."

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

Is there a way to format row height as "AutoFit, but at least 25" (for
example)? AutoFit closes some rows up too tight, but a specific measurement
high enough for all is too big for some.

Ed
 
There is no minimum row height but you could stick an entry out of view in
say column IV with the minimum you want. Autofit would never go below that.
 
Of course. Don't go out any farther than you have to if the usedrange is a
concern. You can hide the cell by hiding the column or using the ;;; custom
number format. Hey, when Excel doesn't behave exactly the way you want you
have to find workarounds.
 
Back
Top