I have an excel table that I set up some time ago. Two of the columns have formulas that in places have been typed over with values and in others have had the formula updated.

I'm at the bottom of the original table now and when I add a new row it auto-fills the original formula I used, not the updated one.

I have previously been able to work around this problem in other tables by deleting the formula everywhere in the column then putting the correct formula in the top cell. That is not as easily possible here since I have put manually values in a number of places. (I can do it in a complicated way.)

Does anyone know how to reset the "default" formulas in an excel table?

I'm using Excel 2010. Thanks.