numbering in excel

Y

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
 
G

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
 
G

Gord Dibben

Thanks for the feedback.

I also liked the other reply you got from JLatham


Gord Dibben MS Excel MVP
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Column Renumbering Question 3
Auto re-numbering when a row is deleted 3
Excel Numbering 4
Consecutive No'ing WHEN ADDING/DELETING ROWS 2
row re-numbering 1
Row Re-numbering 4
Word 2007 not correctly numbering sections 2
Dynamic Range Selection 1,000 rows at a time 8

Top