numbering in excel

[Yookaroo]

I need to renumber column A in an excel workbook that has 127,000 rows right
now the numbering starts at 10, but I need it to start at 1, I know about
dragging the numbers to renumber it, but it takes a very long time to
renumber 127,000 rows, is there a simple way.

If it makes a difference I am on a Mac.




Looking for diet advice?
http://www.w8lossreviews.com

 

[Gord Dibben]

Enter 1 in A1 and 2 in A2

In name box type A1:A127000 and ENTER

Edit>Fill>Series>Linear and OK


Gord Dibben MS Excel MVP

 

[Yookaroo]

Thank you that worked perfectly saved me a lot of time.

 

[Gord Dibben]

Thanks for the feedback.

I also liked the other reply you got from JLatham


Gord Dibben MS Excel MVP

 

[Jacob Skaria]

Enter 1 in A1 , enter 2 in A2.
Select A1:A2 and double click the selection handle (right-bottom of the
selection rectangle)

If this post helps click Yes