I have an excel table we use for data entry for payroll.

Several columns have formulas in them. I had to change the formulas to reference a different cell.

When a new row is added the old formula keeps being used as the default formula entered in that column despite (from what I can tell) all the formulas in that column in the other rows are the new formula.

How can I make excel update new rows with the formula I want?

Thanks.