How to Create & Insert Unique Sequential Numbers in Excel Office 365?
Tags: createinsertuniquese, kutoolsexceltutorial, kutools
Published: 2020-11-19 09:58:52

---
title: How to Create & Insert Unique Sequential Numbers in Excel Office 365?
published: true
date: 2020-11-19 07:11:24 UTC
tags: CreateInsertUniqueSe,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-create-insert-unique-sequential-numbers-in-excel-office-365/
---

Let us see the simple instructions to **Create & Insert Unique Sequential Numbers in Excel Office 365** with **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Create and Insert Unique Sequential Numbers in a Range of Cells:

If you want to create and insert unique sequential numbers in Excel, do the following steps.

- First, you need to **select the range** that you want to insert sequential numbers.

![Select a range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-a-range.png)<figcaption id="caption-attachment-17629">Select a range</figcaption>

- Go to the **Kutools Tab, select** the **Insert** option, **choose** the **Insert Sequence Number** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-8.png)<figcaption id="caption-attachment-17630">Kutools Tab</figcaption>

- Next, it will display the **Insert Sequence Number Dialog Box.**
- In that dialog box, you need to **click** the **new** button to expand this dialog box.

![Click New button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-New-button.png)<figcaption id="caption-attachment-17631">Click New button</figcaption>

- In the **lower-left pane** of this dialog box, you need to create your own sequential numbers and you can see the preview results on the right side list box.

- **Name –** Here, you need to **enter the name** of your data.
- **Start number –** You need to **select the start number** from the drop-down list.
- **Increment –** Use the drop-down menu to choose the increment.
- **No. of digits**  **–** You need to select the number of digits using the drop-down list.
- **prefix (optional) & Suffix (optional) –** You can enter any data in these text boxes.

- After finishing your settings, **click** the **Add** button to add your created sequence to the list box.

![Click the Add button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-the-Add-button.png)<figcaption id="caption-attachment-17632">Click the Add button</figcaption>

- Then, **select** the **item** that you created and **click** the **Fill Range** button to insert the sequence numbers into the selected range.

![Click Fill Range option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-Fill-Range-option.png)<figcaption id="caption-attachment-17633">Click Fill Range option</figcaption>

- After inserting the sequence numbers, you need to close this dialog box.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Output-12.png)<figcaption id="caption-attachment-17634">Output</figcaption>

## Steps to Create and Insert Repeated Sequential Numbers in a Range of Cells:

To create and insert repeated sequential numbers in a range of cells in Excel, do as follows.

- You need to **select the cells** that you want to insert the repeated sequence.

![Select a range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-17.png)<figcaption id="caption-attachment-17649">Select a range</figcaption>

- On the **Kutools Tab, select** the **Insert** option, **choose** the **Insert Sequence Number** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-8.png)<figcaption id="caption-attachment-17630">Kutools Tab</figcaption>

- Then, it will open the **Insert Sequence Number Dialog Box.**
- You need to **click** the **new** button to expand this dialog box.

![Click New button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-New-button.png)<figcaption id="caption-attachment-17631">Click New button</figcaption>

- In the left lower pane, you can **create your own sequential number** s.

- **Name –** Here, you need to **enter the name** of your data.
- **Start number –** You need to **select the start number** from the drop-down list.
- **Increment –** Use the drop-down menu to choose the increment.
- **No. of digits**  **–** You need to select the number of digits using the drop-down list.
- **prefix (optional) & Suffix (optional) –** You can enter any data in these text boxes.

- **End number –** You need to check this box and **enter the number** that how many times you want to repeat the sequence.
- You can **preview the results** in the lower right list box.
- After finishing your settings, **click** the **Add** button to add your created sequence to the list box.

![Insert Sequence Number Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-30.png)<figcaption id="caption-attachment-17637">Insert Sequence Number Dialog Box</figcaption>

- Then, **select** the **item** that you created and **click** the **Fill Range** button to insert the sequence numbers repeatedly into the selected range.
- Then, **close** the dialog box.

![Click the Fill Range button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-29.png)<figcaption id="caption-attachment-17638">Click the Fill Range button</figcaption>

- At last, you can get the result as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-14.png)<figcaption id="caption-attachment-17650">Output</figcaption>

## Create and Insert Unique Sequential Numbers in Merged Cells:

To insert unique sequential numbers in the merged cells, follow the below instructions.

- You need to **select the merged cells** that you want to fill the sequence numbers.

![Select the merged cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-24.png)<figcaption id="caption-attachment-17640">Select the merged cells</figcaption>

- On the **Kutools Tab, select** the **Insert** option, **choose** the **Insert Sequence Number** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-8.png)<figcaption id="caption-attachment-17630">Kutools Tab</figcaption>

- Then, it will open the **Insert Sequence Number Dialog Box.**
- You need to **click** the **new** button to expand this dialog box.

![Click New button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-New-button.png)<figcaption id="caption-attachment-17631">Click New button</figcaption>

- In the left lower pane, you can **create your own sequential number** s.

- **Name –** Here, you need to **enter the name** of your data.
- **Start number –** You need to **select the start number** from the drop-down list.
- **Increment –** Use the drop-down menu to choose the increment.
- **No. of digits**  **–** You need to select the number of digits using the drop-down list.
- **prefix (optional) & Suffix (optional) –** You can enter any data in these text boxes.

- You can **preview the results** in the lower right list box.
- After finishing your settings, **click** the **Add** button to add your created sequence to the list box.

![Click the Add button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-20.png)<figcaption id="caption-attachment-17641">Click the Add button</figcaption>

- Then, select the item that you created and **click** the **Fill Range** button.

![Click Fill Range option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-19.png)<figcaption id="caption-attachment-17642">Click Fill Range option</figcaption>

- It will insert the sequence numbers repeatedly into the merged cells.
- At last, you need to **close** the dialog box.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-17.png)<figcaption id="caption-attachment-17643">Result</figcaption>

## A Brief Summary:

In this post, you can clearly understand the steps to **Create & Insert Unique Sequential Numbers in Excel Office 365** with **Kutools.** Give your **feedback/suggestions** in the below comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Hide Or Unhide Formulas When Protecting A Worksheet in Excel?](https://geekexcel.com/how-to-hide-or-unhide-formulas-when-protecting-a-worksheet-in-excel/)
- [Calculate Cell Values Based on Font, Background, or Conditional Color in Excel 365!!](https://geekexcel.com/wp-admin/post.php?post=17430&action=edit)