Forum Discussion
My table does not auto-insert all the formulas when a new row is inserted
Hi, My excel sheet has 5 columns with formulas. I converted it into a "Table" so that those formulas auto-fill whenever I insert a new row (between rows). Upon inserting a new row, only 4 out o...
Hi Reemav,
I am facing the same problem with my tables. What I noticed is that whenever the formula references the column name instead of the letter/number reference, it is automatically filled whenever a new row is added.
Try to use the cell references as the column names and it should work as long as you're referencing cells from the same row. I am still trying to figure out how to do it for references in different rows.