Help!

[aj2001]

I'll get straight into it, i have a very large sheet with cells A1 to O50 filled with data. i have also made inserted a table, "Table1" into those cells due to the fact that i need to use pivot tables. numerous columns contain formulas which are cell dependant. my question is, when i insert a new row into the end of that table to add new data, how do i automatically make the formulas continue? i tried to insert a new row but it only works for a few columns and other columns i have to manually drag the formulas down.

thanks alot for your help!
aj2001

 

[alvin-chung]

Hi, have you tried use the Insert button in the Menu ribbon?
That shall automatically add a new row with formula copying from prev row.