R Roxie Mar 23, 2009 #1 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?
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?
J Jacob Skaria Mar 25, 2009 #2 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
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