I seem to have a problem with my excel table.

To make it clear, it's a table within the sheet, so not just the normal cells.

After creating a formula in a column (say for example `=A1+A2`

), this is applied to the entire column. Okay, so far so good.

However I discovered an error in the formula (say `A1`

needed to be changed to `C1`

) and changed the formula accordingly.

Everything seems fine, but when I add rows it autofills the cells of that column with the **'old'** formula.

So instead of containing `=C1+A2`

the formula `=A1+A2`

appears.

The Excel error message states that the other cells are not the same as the column formula (with the green triangle at the topleft corner).

Any help would be appreciated!

entire column", do you mean theENTIREcolumn or only to the end of the table? – CharlieRB Jul 11 '17 at 13:09Overwrite all cells in this column with this formula"? Mine did. I used it and then when I added a row, the formula was correct. – CharlieRB Jul 11 '17 at 14:06