99.2% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
Using Autonumber in Excel
Using autonumber in Excel can be very useful. Excel will automatically generate a list of unique numbers for you.
The benefit of creating an autonumber is that it allows you to assign a unique number or code against each row of data in your workbook which helps identify records quickly and allows filtering of records.
This technique would be useful in such business environments such as HR and Procurement. In these environments, you may need a unique number for an employee and a unique number for each product bought.
To get Excel to create your list of numbers click beside your first record and enter the starting number. Next click beside the next record and enter the second number in the series. Finally highlight the two numbers you have entered then use the drag fill handle in the lower right corner of your selection to drag the selection beside the rest of your records.
Excel will use the first two numbers as a pattern for the sequence of numbers it generates for the rest of the list.
Related forum posts:
Hello, Please could you help me understand how to use autonumber in Excel. Sometimes I can get it to work and at other times not very well. I would be interested to know how it applies to dates as well as numbers. Regards Richard
Is there a way of generating automatic numbers / identifiers in Excel for each record created in a speadsheet? I would also like the number / identifier to have a specific format (i.e. 3 letters/year/3 digit number). Thanks.
Other posts you might be interested in:
i need to add a prefix depending on a selection made from a combo box in a form how would i go about this?
How do I set up an alpha-numeric autonumber?
Discover how to use the versatile Fill feature in Excel to save you time when you need to fill text, numbers, dates and custom lists.
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Any suggestions, questions or comments? Please post in the Improve the forum thread.