the row height should be excatly the height of the data

[jaggu]

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

 

[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

 

[Gord Dibben]

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

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


Gord Dibben MS Excel MVP