title: How can I disable excel formula autofill?
body: <p>Sometimes, when I enter in a value into a cell in an excel cell, the cells in the adjacent column(s) will automatically populate with the formula of the cell above them.</p>
  
  <p>Here is a test case which causes the behavior. Attempting to enter in a value in cell A5 will autofill the formula into cell B5. Note: This does not occur with 3 or less rows.</p>
  
  <pre><code>     A   B
  1    0   =A1
  2    0   =A2
  3    0   =A3
  4    0   =A4
  5            
  </code></pre>
  
  <p>I have already taken the steps on this page (disable formula autocorrect), to no avail: <a href="http://www.k2e.com/tech-update/tips/823-tips-disabling-formula-replication-excel-tables" rel="nofollow">http://www.k2e.com/tech-update/tips/823-tips-disabling-formula-replication-excel-tables</a></p>
  
  <ol>
  <li>Is there any way to stfop this from happening?</li>
  <li>Can this behavior be disabled on a workbook/user/computer level
  so I never have to deal with it again?</li>
  </ol>
  
  <p>EDIT: Here is a gif of the behavior, to better explain: <a href="http://imgur.com/m1ELwt8" rel="nofollow">http://imgur.com/m1ELwt8</a></p>