Skip to main content

Quickly create and insert unique sequential numbers in Excel

Kutools for Excel

Boosts Excel With 300+
Powerful Features

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


Click Kutools >> Insert >> Insert Sequence Numberto enable the feature. See screenshots:

doc insert sequence number 03


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.

doc insert sequence number 03

2. In the Insert Sequence Number dialog box, specify the fill order first. Choose to Fill vertically cell after cell or Fill horizontally cell after cell from the Fill order drop-down list.

doc insert sequence number 04

3. Still in the Insert Sequence Number dialog box, please click doc insert sequence number 05New button to create your own sequential numbers.

4. In the popping-up Create Sequence Number dialog, under the Sequence number section, specify the Name, Start number, Increment, No. of digits one by one accordingly. The End number, Prefix, and Suffix options are optional. Then you can preview the result of your customized sequence in the right list box, see screenshot:

doc insert sequence number 06

5. After finishing your settings, click OK button. The newly created sequence numbers item is added into the Sequence number list.

doc insert sequence number 07

6. In the Insert Sequence Number dialog box, select the item that you created from the Sequence number list, then click the OK button to insert the sequence numbers into the selected range. The result is shown as the below screenshot.

doc insert sequence number 08

Tip: Click Ok button will close the dialog box and apply the operation; but click Apply button will only apply the operation without closing the dialog box.


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.

doc insert sequence number 09

3. In the Insert Sequence Number dialog box, specify the fill order first. Choose to Fill vertically cell after cell or Fill horizontally cell after cell from the Fill order drop-down list.

doc insert sequence number 10

4. Still in the Insert Sequence Number dialog box, please click doc insert sequence number 05New button to create your own sequential numbers.

5. In the popping-up Create Sequence Number dialog, under the Sequence number section, specify the Name, Start number, End number, Increment, No. of digits, and Prefix one by one accordingly. Then you can preview the result of your customized sequence in the right list box, see screenshot:

doc insert sequence number 11

6. After finishing your settings, click OK button. The newly created sequence numbers item is added into the Sequence number list.

doc insert sequence number 12

7. In the Insert Sequence Number dialog box, select the item that you created from the Sequence number list, then click the OK button to insert the sequence numbers into the selected range. The result is shown as the below screenshot.

doc insert sequence number 13


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, after specifying the fill order from the Fill order drop-down list, click doc insert sequence number 05New button to create your own sequential numbers.

doc insert sequence number 14

3. In the popping-up Create Sequence Number dialog, under the Sequence number section, specify the Name, Start number, Increment, and No. of digits one by one accordingly. Then you can preview the result of your customized sequence in the right list box, see screenshot:

doc insert sequence number 15

4. After finishing your settings, click Ok button. The newly created sequence numbers item is added into the Sequence number list.

doc insert sequence number 16

5. In the Insert Sequence Number dialog box, select the item that you created from the Sequence number list, then click the Ok button to insert the sequence numbers into the selected range. The result is shown as the below screenshot.

doc insert sequence number 17

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 started from the sequential number in the Next list. See screenshot:

    doc insert sequence number 18

  2. You can click New button to create more sequential numbers.
  3. This utility supports Undo (Ctrl+Z).

Productivity Tools Recommended
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 30 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Comments (2)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
How to add a serial number to the repetitive keyword appearing in different rows, in a column ?
This comment was minimized by the moderator on the site
Hi there,

You can use Kutools to first select the cells with the repetitive keyword:

1. Click Kutools > Select > Select Specific Cells.
2. In the pop-up dialog, please configure as follows:
a. Select the column with the repetitive keyword as the range.
b. Select Cell as the selection type.
c. Under Specific type, set the type as Contains, and fill in the keyword in the corresponding box.
3. Click OK. Then only the cells with the keyword will be selected.

Now, please use the Insert Sequence Number feature by following the instructions in this page.

Amanda
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations