If you wish to have an auto numbering column with excel, you could fill up the 1st and 2nd number and drag the handle to as far as how you want your numbering to go. However, you will need to keeping doing the same operation if you have rows deleted. Following is a method that you could use to take care of rows deletion.

1. Put this forumla to the cell that you want autonumbering to start: =ROW()-ROW(A$1)
2. Copy this cell to as far as you want the autonumbering to go in your Excel spreadsheet.

 

Difficulty level: Easy
Recurring Risk: No

 Want us to do this for you? It takes about 1 hour depending on the size of site.
Skill level required – Expert level
Our rate is $20 per hour ( min. 2 hours)
Call us at: +65 6511 4585 (Office hours)
Message us at: +65 8263 1460 (24 hours)
Email us at: enquiry@dyontech.com
Visit our website at: www.dyontech.com