the row height should be excatly the height of the data
 

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

the row height should be excatly the height of the data
 

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

"jaggu" wrote:

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

the row height should be excatly the height of the data
 

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

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


Gord Dibben MS Excel MVP

On Thu, 6 Nov 2008 02:46:00 -0800, jaggu
wrote:

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