I have some tables where upon adding data makes the table miraculously duplicate the formulas from the table into the new row making my work easy. Now trying to duplicate this function with a new different table it's not working. I'll add data into the row below the table and at least it adds the new row to the table but does not insert the table's formulas into it. So why does this happen with my other tables? is it because the formulas in my other tables include ranges running down the columns that excel recognizes and adds to this range automatically? either way, how do I get excel to do this with my current tables that have formulas that only deal with cells along the same row? Thanks