Forum Discussion

Iron Contributor

Aug 09, 2018

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

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...

Excel 2016

Tables

Detlef_Lewin

Silver Contributor

Aug 09, 2018

Hello Lou.

The solution is pretty simple here. We just have to apply the number formatting to all cells in the column at the SAME TIME.

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