When cell inserted, formula automated

[firstWeMeet]

How to setup this?
when I insert a row formula will automatic formula too at the new inserted row, like our table, when we insert a row they have auto formula. for excel 2007. please help. thanks

 

[Peter_SSs]

Not exactly sure what you are asking but I think the best you can do is:

Office icon|Excel Options|Advanced|Extend data range formats and formulas.

When you add data on a new row at the bottom the formulas should be extended. However if you insert a new row into the worksheet, the formulas will not automatically populate.