Updating Formula in a Excel Table

[mahhdy]

Hi Guys,
I have an Excel table with some formula columns. In that columns, the value of some cells is calculated by formula and some rigid contents as text. I want to update the base formula for the new lines. For the current cells I am doing a is formula test and update them manually, but for the new row, sometimes I forget to update them, so it cause some mistakes.

Can anyone help?

 

[arthurbr]

Difficult to say withouts having an idea of the formula.
However if they contain ranges try https://exceljet.net/formula/dynamic-named-range-with-index or insert a table. Formulas will then update as rows are added
(PS try to avoid dynamic ranges using the OFFSET function, as this one is volatile)