How can I disable excel formula autofill?
<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>