R Roxie Mar 23, 2009 #1 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.
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.
A Ashish Mathur Mar 23, 2009 #2 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
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
G Gord Dibben Mar 24, 2009 #3 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
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
