title: How to apply formula to a whole column?
body: <p>I need to subtract the minimum of that column from all rows of the column in Excel. I have one million rows and I cannot drag the right corner of the cell box all the way down to apply the formula to all those cells. I unfortunately haven't found anything that works. I want to subtract the minimum of a column from each cell of that column divide by 1000 and store in another column:  </p>
  
  <pre><code>=(B1-MIN(B:B))/1000
  </code></pre>
  
  <p>How do I apply this to all rows of the column where I want this to work? </p>
  
  <p>How do we apply formulas in general to all rows of a column in general?</p>