Numbering Rows

[Roxie]

I would like to number rows in a spreadsheet. A2= 1, A3= 2, etc to #2007.
What is the best way to do this?

Thank you.

 

[Ashish Mathur]

Hi,

In A2, type 1, in A3 type, A2+1 and copy down till row 2006

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Gord Dibben]

In A2 enter =ROW()-1

Copy down to row 2008

OR In namebox enter A2:A2008 and ENTER to select that range.

In Active cell enter =ROW()-1 then hit CTRL + ENTER to copy down.


Gord Dibben MS Excel MVP