Formula not copying down when inserting new row

[swoosh1014]

Hello,

I am having an issue getting a few of my formulas to copy down to a newly inserted row within my table. I know one of the advantages of having your info in a table is that this is supposed to happen automatically, but for whatever reason a few of mine arent working. Is there a simple fix to this? I would like to avoid having to manually drag the cell above down to copy the formula each time I insert a new row.

Thanks!

[buzzbee]

One thing to try, but I am not sure if it will work...
Click on file and then options. In the pop-up box, click on Advanced and ensure the check box is ticked for 'Extend data range formats and formulas'

I believe this will only work if the same formula is present in the three cells above

[swoosh1014]

Thanks for the reply! So i went into the options and that box was checked and the formula is present in 100+ cells above any newly insterted row.