Share via

Formula replication not working in a table

Anonymous
2018-07-11T16:22:49+00:00

Generally, Excel copies formulas when a new row is added to a table.

I have just added a bunch on new columns to an existing table (say columns R to X) and populated the new rows and columns with a formula - which progresses conforming to the usual rules for relative references in adjacent rows and columns.

However, for any new row added to the table after this point, the cells is columns R to X are not being automatically populated with formulas derived from the rows above.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2018-07-11T17:09:15+00:00

If you convert it to a range and then back to a table, does that fix it?

Was this answer helpful?

3 people found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-07-11T17:14:47+00:00

    Excellent - thanks Jason!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2018-07-11T16:54:50+00:00

    Nothing different

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-07-11T16:25:32+00:00

    Are the new formulas different than the other formulas in the same column?

    Was this answer helpful?

    0 comments