title: How to make a repeating pattern in MS Excel with running alphabet letters and numbers
body: <p>I've been trying to search the web for an answer with no avail so I decided to ask this here. I have a matrix in MS Excel and I would like to find a repeating pattern on the last row of the matrix such that both the column letter and the row number are running in the pattern.</p>
  <p>I tried creating this pattern in the usual way by making few examples in the excel and then dragging the +-sign over the cells. However, only the alphabetical letter runs in the pattern but the numbers do not.</p>
  <p>I have below a minimal working example. I have a 4 x 4 matrix and I would like the last row to contain all the diagonal elements of the matrix, that is the numbers 1, 6, 11 and 16. But when I try to repeat the pattern after manually plugging into the first three cells of the blue row as:</p>
  <pre><code>=A1, =C2, =B3
  </code></pre>
  <p>Then when I try to use the +-sign and repeat the pattern only the letter is incremented and I get the value in cell D1 instead. How to create a pattern which reads the diagonal elements of the matrix? Thank you!</p>
  <p><a href="https://i.stack.imgur.com/dySyY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dySyY.png" alt="enter image description here" /></a></p>
  <p><strong>UPDATE:</strong> Thank you everyone for your help. One addition to previous, many of the given formulas (for example the INDEX-approach) seem to work when my matrix is in the top-left corner of the Excel-file. I noticed that if I add rows or columns to the excel (above and on the left side of the matrix) the formula produces different values, why is this?</p>
  <p>Here you see the INDEX-approach prior to adding any columns to excel:</p>
  <p><a href="https://i.stack.imgur.com/TKvnr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TKvnr.png" alt="enter image description here" /></a></p>
  <p>And here you see the same matrix and formulas after adding one column on the left side of the matrix:</p>
  <p><a href="https://i.stack.imgur.com/WsJBE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WsJBE.png" alt="enter image description here" /></a></p>