Using Autonumber in Excel

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Topics » Using Autonumber in Excel

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:

Autonumber in Excel

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

Read forum post


Automatic number generation

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.

Read forum post


Other posts you might be interested in:

Adding a prefix to an auto number

i need to add a prefix depending on a selection made from a combo box in a form how would i go about this?

Read forum post



How do I set up an alpha-numeric autonumber?

Read forum post


Related articles

Discover How To Use Fill In Excel

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.

Read article



Training courses


Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Server loaded in 0.06 secs.

✓ w3speedster