Insert row with the same formula

[ariaaria]

Hi,

I'm quite new to Excel. I am now using Office 2011 for Mac. I have created a work sheet and assigned a formula to 4 rows. I want to insert a new row in the middle of those 4 rows and to have that row have the same formula. How do I do this? When I insert a new row, the formula doesn't follow.

I see that on one of the templates... When I click to insert row in the same way, the formula follows.

Please advise.

Thanks