auto formula fill after data entry

[loudog]

what is the trick to have a formula fill down after a new row of data i
entered. for example if i wanted to calculate miles per hour, i woul
have three cells in a row; miles, hours and the formula of cell1/cell2
i want the formula in cell3 to automatically fill down when i ente
values in cells 1 and 2 in each successive row.
thanks in advance,
joe

 

[Debra Dalgleish]

The following MSKB articles explain how Auto Extend works:

XL2000: How Auto Extend List Behavior Works
http://support.microsoft.com/?id=231002

XL2000: Entering Data in List May Not Extend Formats as Expected
http://support.microsoft.com/?id=230584

 

[loudog]

thanks...my problem is i only had three row

 

[Debra Dalgleish]

You're welcome. I glad you solved your problem.

thanks...my problem is i only had three rows