title: I have filtered my Excel data and now I want to number the rows. How do I do that?
body: <p>Basically all I want to do is to insert a new column after having filtered my data by a certain criterion, and then insert consecutive numbers into that column, one for each row. I.e., I have data like this in one column:</p>
  <blockquote>
  <p>Armstrong, John</p>
  <p>Beattie, Jane</p>
  <p>Coombs, John</p>
  </blockquote>
  <p>And I want a new column running next to it so it looks like:</p>
  <blockquote>
  <p>1   Armstrong, John</p>
  <p>2   Beattie, Jane</p>
  <p>3   Coombs, John</p>
  </blockquote>
  <p>I have tried inputting the first few numbers and then dragging down to fill the rest of the column but when I do that all of the numbers turn to 1 for some reason.</p>