Autofill formulas when inserting new rows

[Ahmed Hashish]

Hello,
As title suggests, I couldnt solve this issue when inserting a new row to the end of a table, usually it picks up formula from the previous row but its not working now(new row is totally empty without formulas) , and also the numbering (sequence) column that I have as first column in the table.

Edit: searched this over, suggested solution is to format range as table, but in my case its already a table, but something is broken in it

Thanks and appretiate your help.

 

[JerrExcel]

Hi there,

If all of the data is included in the range of table, then the autofill might somehow broken.
Try Delete all formulas in the column except one (the first data row). Then, go to that cell with the formula and press F2 and ENTER.
For the numbering (sequence) column, you can use formula =ROW(A1) or =ROW(A1)-1
Then try to add a new row again.

Thanks!