title: Auto fill a total row in an Excel table
body: <p>Is it possible to quickly select one formula for all of the cells in a total row of an Excel table? I have about 10 tables with 10 columns each and I want to set the total row formula to be sum of the row above, but right now I have to manually select sum for each cell. </p>
  
  <p>If I copy and paste from one cell to its horizontal neighbors, the table referencing causes all the neighbors to sum the original column. If I set the formula manually using cell references (b1:b10), then those references get broken if the table expands. So I'd like a way to sum the entire row, and have that formula apply across all cells in the total row.</p>