title: How to divide an entire column by the sum of it's average in excel
body: <p>Hello I have a large file in excel. I was able to calculate the average for an entire column by using <code>=AVERAGE(A2:A34315)</code> and got it's average. Now i'm trying to divide the entire column by it's average. Is there an easier way to do this without me going into a new column and manually typing it. For example let's take the average number to be 1000 </p>
  
  <pre><code>=A2/1000
  </code></pre>
  
  <p>I don't want to type this all the time or drag because the file i have is large. The columns start from 2 all the way to 34315. Reason for doing this is i'm trying to normalize or scale the data. </p>