title: Excel - Drag and repeat formula pattern series
body: <p>I am trying to replicate a pattern of formulas in excel but it's not appearing the way I expect but I'm looking for a solution.</p>
  
  <p>I have the first 2 rows in a table defined and it has 4 columns</p>
  
  <p>The formulas are as follows:</p>
  
  <pre><code>A1 =CONCATENATE(Scores!D11," (",Scores!F11,")")
  B1 =Scores!AF11
  C1 =Scores!AH11
  D1 =Scores!AH15
  
  A2 =CONCATENATE(Scores!D17," (",Scores!F17,")") 
  B2 =Scores!AF17
  C2 =Scores!AH17
  D2 =Scores!AH21
  </code></pre>
  
  <p>I expected when I highlight the cells and dragged down that it would repeat the formula by adding 6 to all the value as shown above.</p>
  
  <p>Is there an easy way to autofill the rows I need as I have to populate over 80 and possible more in the future.</p>