the row height should be excatly the height of the data

J

jaggu

I an excel sheet I want all the rows to fit the data without using the mouse
or the row height audjustment
 
M

Mike H

Hi,

Right click your sheet tab, view code and past this in

Private Sub Worksheet_Change(ByVal Target As Range)
Target.EntireRow.AutoFit
End Sub

Mike
 
G

Gord Dibben

CTRL + a(twice in 2003) to select all cells.

Alt + o + r + a to autofit all rows.


Gord Dibben MS Excel MVP
 
Top