Forum Discussion

Iron Contributor

Jan 30, 2021

Excel table does not autofill formulas

I created a table. When I add or insert new rows the formulas do not autofill into the new row. I must copy and past the formula into the new row cell. I understand this is not the normal behavior ...

wcstarks

Iron Contributor

Feb 15, 2021

CloudSalvation

Thanks for your response. In the meantime, I realized that the formula that would not auto-fill was first created before the column was included in the table. Apparently, when a formula is created outside the table and later becomes part of a table, Excel will not deal with it properly. I eventually re-did the formula for that column from within the table, and now it does auto-fill as expected.

jmaxwell1337

Copper Contributor

Mar 07, 2023

Thank goodness you posted this. I was really circling around trying to figure this out. recursion is not a given I guess?

Riskyplan
Copper Contributor
May 17, 2024
jmaxwell1337 adding my experience with this to perhaps help. I had a table with a reference to a constant cell ($C$12). when the table expanded down the referenced cell did not. Interestingly the rest of the formula did expand, but the $C$12 became C7, C8,C9 respectively. I tried changing the reference to an Index(C12,1,1) but again, this part of the formula was overridden when expanding down. What worked for me was to convert the table back to a normal rage, and then select and insert it again using the same table name.