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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,456
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,652
Messages
5,549,210
Members
410,905
Latest member
Extjel
Top