AutoFit Row Height

[bburden725]

I read somewhere if you manually adjust the row height, that AutoFit Row Height will not work,. That is the problem I am having. I have 7,721 rows in my spreadsheet. Some rows have 1 row of text, some 2, and even more sometimes. The problem I am having if I have to move a section of data somewhere else on the sheet, it will not maintain the original format. Before I started this sheet, I turned on wrap text and AutoFit Row height. I don't understand why it won't re-adjust.

Is there a macro or anything I can get help with in solving this problem? Thanks in advance.

 

[MARK858]

For me Autofit doesn't work if double click the line above the row number but does if you double click the line below the row number.