title: Increment row, not column of spreadsheet
body: <p>I am working on a spreadsheet that tracks my running mileage. I've got all my miles in one column, but I want to be able to create a "Calendar View" of sorts, so I can track my miles on Mondays, Tuesdays, etc. </p>
  
  <p>To do this, I am using: =Mileage!C13 for cell b2.
  For cell B3, I want: =Mileage!C14.</p>
  
  <p>Obviously, I will be using 7 columns for the calendar, but when I try to create a series in the row, it increases the column (instead of C14, it gives D13).</p>
  
  <p>Also, I tried doing a series in the column instead, and increasing by 7 with no luck.
  B2: =Mileage!C13. B3=Mileage!C20. If I select both cells and try to create a series, it gives me =Mileage!C14 instead of =Mileage!C27. </p>
  
  <p>I hope this makes sense... any tips, or am I going about this completely wrong? Thanks!</p>