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.

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

"Roxie" wrote in message
...
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.

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

On Mon, 23 Mar 2009 16:40:01 -0700, Roxie
wrote:

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.