title: 'Drag down' formula over 20,000+ rows without manually having to drag down and wait
body: <p>Ive got a google docs spreadsheet with c. 20,000 rows ive got a formal i want to run for each row, at the moment im inputting the formula into <code>D1</code> and then pulling the formula down, although this works i have to wait with my hand on the mouse for about 5 mins to reach the bottom of the spreadsheet. </p>
  
  <p>Is there a quicker / better way to do this ?</p>
  
  <p><strong>UPDATE</strong> Ive made an example google drive spreadsheet here : <a href="https://docs.google.com/spreadsheets/d/1GyPEcTclo-7HGrGkpp86WyguKF6VJblCzBE9qXm-7mU/edit#gid=647850816" rel="nofollow">https://docs.google.com/spreadsheets/d/1GyPEcTclo-7HGrGkpp86WyguKF6VJblCzBE9qXm-7mU/edit#gid=647850816</a> </p>
  
  <p>Ive got the numbers 1-500 in cells A1-A500 in B for each row ive written a formula to check if a the number is odd or even. For this example (500 rows) its not a problem to drag the formula down, but this is just an example data set. </p>