Hi Asu,
SInce you have multiple (completely different) answers and have not indicated any of them
answered your question, possibly by adding you mean inserting and
you might look at
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
to help you continue formulas down from previous rows.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm