title: How do I prevent Excel from automatically replicating formulas in tables?
body: <p>I'm using Excel 2016. I have a table with headers and when I plug in a formula, Excel is automatically replicating the formula to all other cells in the column. While that would normally be fine, it's wrongly calculating the table headers. I thought I could just change the top row to exclude the header but Excel updates the rest of the column which I don't want.</p>
  
  <p>I would like to either turn this automatic formula replication feature off or figure out a way to customize the formula in the top row so it doesn't calculate the header value.</p>
  
  <p>Here's the formula I'm using and I didn't do anything special with the table outside of add a 'Totals' row:</p>
  
  <pre><code>=SUM(B2+C1-D2)
  </code></pre>