In a Table - Change a calculated formula in a table and make that the new "default" formula for that column?

[Smokeyham]

Hello,

I have a table with a number of calculated columns. I would like to change the formula in one column, and want to keep the formula for the previous entries, but when I enter a new row (which automatically expands the table) then I would like the new formula to be the default which is filled in automatically.

When I try this with the new formula in the row above, the old formula is automatically filled into the new row and I have to copy my new formula from the row above and paste it into the cell.

Any thoughts on how I change the default?

Thanks!

 

[GilbW]

I haven't been able to edit the default formula, but it is possible to change it by deleting all cells in the row or column, then entering a new formula.
You can then change individual cells as required, and new rows or columns will be have the relevant cell filled with the new formula.

 

[Smokeyham]

I haven't been able to edit the default formula, but it is possible to change it by deleting all cells in the row or column, then entering a new formula.
You can then change individual cells as required, and new rows or columns will be have the relevant cell filled with the new formula.

Thanks for the response.

The issue I have is that I want to keep the formulas in the previously entered rows, so deleting them does not meet the need.

I have also tried leaving a blank row, creating new formulas and then deleting the blank row above to incorporate the row with the new formulas into the named table, but all that happens is that the new row updates with the old formulas.

 

[GilbW]

@Smokeyham,
If you want to keep the current formulae: add a new row, type in the new formula, which will populate the entire row, cut and paste the formulae you wish to keep from the old row, then delete the old row.
I know it would be better if you could edit the default formula for future cells, but it seems there is no way to do that ?