inserting a row in excel

A am currently working on a project where have about 20 colums and about 100 or so rows. Now my problem is i need to be able to insert a row somewere in those other rows and when i insert that row i need theformula to automatically appear in the inserted cell… how could i do this