Numbering Rows

[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?

 

[Chin]

You can try one of the following:

(1) Key in a formula at cell A4 =A3+1, then click and drag down the cross-
hair (bottom right) at cell A4 to A2006.

(2) If you are using Excel 2007, highlight A2 and A3, click and drag down the
cross-hair at cell A3 to A2006.

 

[Jacob Skaria]

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