title: Excel : Increment Row number on fill right
body: <p>When one "Fills right in excel" , the Column name updates</p>
  
  <p>eg.</p>
  
  <p>1st cell
  is
  =A2</p>
  
  <p>If I fill right the next cell will be =B2</p>
  
  <p>But rather than the column incrementing I want to increment the row number</p>
  
  <p>so 1st cell is
  =A2</p>
  
  <p>The cell on its right is
  =A3</p>
  
  <p>how do i do that?</p>