Excel Table AutoExpansion not extending all formulas to the new row when I add a new value

Question

Using Excel for O365.&nbsp; I have large table with many columns.&nbsp; When I add a new value in a column at bottom of the table, only about 50% of the formulas propogate to this new row.&nbsp; Not sure how to fix it.

detlef_lewin · Answer

Hello Lou.&nbsp;The solution is pretty simple here. We just have to apply the number formatting to all cells in the column at the SAME TIME.&nbsp;And that applies not only to formatting but also to formulas and data validation.&nbsp;

Forum Discussion

Excel Table AutoExpansion not extending all formulas to the new row when I add a new value

1 Reply

Resources