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

[Lou Mickley]

Using Excel for O365.  I have large table with many columns.  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.  Not sure how to fix it.

[#2]

Hello Lou.

The solution is pretty simple here. We just have to apply the number formatting to all cells in the c...

And that applies not only to formatting but also to formulas and data validation.