AutoFit Row Height

bburden725

New Member
Joined
Apr 18, 2015
Messages
3
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.
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,430
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,108
Messages
5,545,987
Members
410,718
Latest member
ALM1GHTY
Top