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.
Bookmarks