Numbering Rows

  • Thread starter Thread starter Roxie
  • Start date Start date
R

Roxie

I would like to number rows in a spreadsheet. A2 = 1, A3 = 2, etc to row
2006. What is the easiest way to do this?
 
Dear Roxie

You can also try A2=ROW()-1 which will maintain the row numbering even if
rows are deleted from inbetween. Its up to your requirement.

If this post helps click Yes
 
Back
Top