Quickly create and insert unique sequential numbers in Excel
Kutools for Excel
Normally it is easy to insert sequence numbers in contiguous cells of Excel by dragging mouse, after you enter two numbers, such as 1 and 2. However, if you want to insert customized sequential numbers in Excel, such as KTE-0001-Jone, KTE-0002-Jone, KTE-0003-Jone..., the sequence strings will not be filled normally when dragging the mouse. Now, with the Insert Sequence Number utility of Kutools for Excel, you can create any customizing sequence numbers and insert them quickly. With this handy utility, you can:
Quickly create and insert unique sequential numbers in a range of cells
Quickly create and insert repeated sequential numbers in a range of cells
Quickly create and insert sequential numbers in merged cells
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
Click Kutools >> Insert >> Insert Sequence Number. See screenshots:
 |
 |
 |
Quickly create and insert unique sequential numbers in a range of cells
If you want to quickly create and fill a range of cell with customized sequential numbers in Excel, you can get it done as follows:
1. Select the range that you want to insert sequential numbers, and applying this utility by clicking Kutools > Insert > Insert Sequence Number to open the Insert Sequence Number dialog box.
2. In the Insert Sequence Number dialog box, please click New button to expand this dialog box. In the lower left panel, create your own sequential numbers, at the same time, you can preview the result of your customized sequence in the lower right list box, see screenshot:
3. After finishing your settings, click Add button to add your customized sequence into the above list box, and select the item that you are created, then click Fill Range button to insert the sequence numbers into the selected range. See screenshots:
 |
 |
 |
4. After inserting the sequence numbers, close this dialog.
Quickly create and insert repeated sequential numbers in a range of cells
Sometimes, you may need to repeat the sequential numbers, such as AA-001, AA-002, AA-003, AA-001, AA-002, AA-003…in a range of cells, the Insert Sequence Number utility also can deal with this job.
1. Select the cells that you want to insert the repeated sequence.
2. Then apply this feature by clicking Kutools > Insert > Insert Sequence Number to open the Insert Sequence Number dialog box.
3. In the Insert Sequence Number dialog box, click New button to expand the dialog. In the lower left panel, create your own sequential numbers, then check End number box and enter the end number that you want to repeat the sequence from. At the same time, you can preview the result of your customized sequence in the lower right list box, see screenshot:
4. Then click Add button to add the new customized sequence into the above list box, and select the item that you are created, then click Fill Range button to insert the sequence numbers repeatedly into the selected range. Then close the dialog box. See screenshots:
 |
 |
 |
Quickly create and insert sequential numbers in merged cells
As we all known, when we want to use the fill handle to fill the sequence numbers into merged cells, the fill handle will not take effect, but, if you have Kutools for Excel, its powerful tool - Insert Sequence Number can solve this task quickly and easily.
1. Select the merged cells that you want to fill the sequence numbers.
2. Then go to the Insert Sequence Number dialog box, click New button to expand the dialog box.
3. In the expanded dialog box, at the lower left panel, create your own sequential numbers, at the same time, you can preview the result of your customized sequence in the lower right list box, see screenshot:
4. After finishing the settings, click Add button to add the created sequence to the above list box, and select the item that you are created, then click Fill Range button to insert the sequence numbers into the merged cells. Then close the dialog box. See screenshots:
 |
|
 |
Tips:
1. In the Insert Sequence Number dialog box, it will mark the last inserted sequential numbers in the Previous list, and if you insert this sequence number at next time, the first sequential number will be marked in Next list. See screenshot:
2. You can click New button to create more sequential numbers.
3. This utility supports Undo (Ctrl+Z).
Demo
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.
Kutools for Excel
The functionality described above is just one of 300 powerful functions of Kutools for Excel.
Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.
