Excel: set default formula for each cell in column

I have a column with the following formula in every cell that calculates the difference in kilometers between the two cells to the left of each cell:

=IF(AND(INDIRECT(ADDRESS(ROW(),COLUMN()-2))<>"", INDIRECT(ADDRESS(ROW(), COLUMN()-1))<>""), INDIRECT(ADDRESS(ROW(),COLUMN()-1))-INDIRECT(ADDRESS(ROW(),COLUMN()-2)), "")

My problem is that every time I insert a new row in between existing data, all the cells are empty in that row and I need to manually put this code into the empty cell.

Is it possible for me to set every cell in a column (excluding the header) to a specific formula even when I insert a new row?

I have tried to set the column as a table, and it was successful in autocompleting the cells whenever I inserted a new row, however, I have other columns that I also want to autocomplete and Excel doesn't let me insert a new row if I make more than one column a table.

I was going to just post this video, but evidently, I have to type at least 30 characters.

How about "Here is an easy way to do it." Darn, that's only 29.

For anyone interested, the "Insert Picture" icon won't accept a .mov, but there's a pretty neat website that will convert video files to animated GIFs.