Autofit for Rows Does Not Work

[Hilary]

Hi!

I have been working with Excel for years and I've always
loved the autofit function for row and columns. With
columns you just double click on the right boundary.
With rows, you just double clicked on the bottom
boundary. I especially like this functionality on rows
when I have a paragraph in merged cells that is set up to
wrap text. I don't want the height of the row to be any
more or less than exactly what is required for the text.
In the past year, despite being on different systems,
nothing happens when I double click on the bottom of a
row. Any ideas?

 

[Boxman]

With columns this works automatically. With rows, you have to first set
the cells to autowrap. Then you can resize to what ever you want and
double click the bottom and it will work as you desire