FIND and FILL Missing Numbers in Sequence in Excel Office 365!!
Tags: kutoolsexceltutorial, stepstofindandfillmi, kutools
Published: 2020-10-06 08:55:25

---
title: FIND and FILL Missing Numbers in Sequence in Excel Office 365!!
published: true
date: 2020-10-05 12:06:45 UTC
tags: KutoolsExcelTutorial,StepstoFindandFillMi,Kutools
canonical_url: https://geekexcel.com/find-and-fill-missing-numbers-in-sequence-in-excel-office-365/
---

In this guide, we are going to explore how to **Find and Fill Missing Numbers in a Sequence in Excel Office 365** using **Kutools.** Let’s get started!! 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.
## Steps to Fill Missing Numbers in Sequence:

To fill the missing numbers in a sequence, you need to follow the below steps.

- You need to select a number sequence and on the **Kutools Tab, select** the **Insert** option, **choose** the **Find Missing Sequence Number** option.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-6.png)<figcaption id="caption-attachment-15174">Example</figcaption>

- It will open the **Find Missing Sequence Number dialog box.**
- In that dialog box, you need to **check** the **Inserting missing sequence number** option.
- Then, **click** the **OK** button.

![Find Missing Sequence Number dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-6.png)<figcaption id="caption-attachment-15175">Find Missing Sequence Number dialog box</figcaption>

- A new dialog box will pop out to tell you how many missing numbers were found in the selected sequence.
- You need to **click** the **OK** button.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-5.png)<figcaption id="caption-attachment-15176">Prompt box</figcaption>

- Now, all the missing numbers have been inserted into the sequence.

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

## Insert Blank Rows while Encountering Missing Numbers in Sequence:

To insert blank rows while encountering missing numbers in the sequence, follow the below steps.

- You need to select a number sequence and on the **Kutools Tab, select** the **Insert** option, **choose** the **Find Missing Sequence Number** option.

![Example Data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-4.png)<figcaption id="caption-attachment-15178">Example Data</figcaption>

- It will open the **Find Missing Sequence Number dialog box.**
- In that dialog box, you need to **check** the **Inserting blank rows when encountering missing sequence numbers** option.
- **Click** the **OK** button.

![Find Missing Sequence Number dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/4-2.png)<figcaption id="caption-attachment-15179">Find Missing Sequence Number dialog box</figcaption>

- It will open a pop-out message to tell you that the number of missing numbers from the sequence.
- **Hit** the **OK** button.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/5-2.png)<figcaption id="caption-attachment-15180">Prompt box</figcaption>

- Now, you can see the result as blank rows are inserted while encountering missing numbers.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/6-2.png)<figcaption id="caption-attachment-15181">Result</figcaption>

## Fill Background Color while Encountering Missing Numbers:

- You need to select a number sequence and on the **Kutools Tab, select** the **Insert** option, **choose** the **Find Missing Sequence Number** option.

![Example Data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-4.png)<figcaption id="caption-attachment-15178">Example Data</figcaption>

- It will open the **Find Missing Sequence Number dialog box.**
- In that dialog box, you need to **check** the **Fill background color** option and **select** a **color** from the given drop-down list as you wish.
- Finally, **click** the **OK** button.

![Find Missing Sequence Number dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/7-1.png)<figcaption id="caption-attachment-15183">Find Missing Sequence Number dialog box</figcaption>

- It will open a prompt box to tell you how many missing values were found.
- Then, **hit** the **OK** button.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/8-1.png)<figcaption id="caption-attachment-15184">Prompt box</figcaption>

- Now, the cells are filled with the background color when encountering missing numbers as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/9-2.png)<figcaption id="caption-attachment-15185">Result</figcaption>

## Insert New Column with Specific Missing Marker:

- You need to select a number sequence and on the **Kutools Tab, select** the **Insert** option, **choose** the **Find Missing Sequence Number** option.

![Example Data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-4.png)<figcaption id="caption-attachment-15178">Example Data</figcaption>

- It will open the **Find Missing Sequence Number dialog box.**
- In that dialog box, you need to **check** the **Inserting new column with the following missing marker** option and **enter** the **marker** into the given text box.
- Then, **click** the **OK** button.

![Find Missing Sequence Number dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/10-1.png)<figcaption id="caption-attachment-15186">Find Missing Sequence Number dialog box</figcaption>

- A dialog box will pop out to tell how many missing numbers were found. **Hit** the **OK** button to get the result.

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

- Now, a new column is inserted next to the sequence, and the marker is inserted when encountering the missing sequences as shown in the below image.

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

## End of the Article:

In this guide, you can clearly learn the steps to **Find and Fill Missing Numbers in a Sequence in Excel Office 365** using **Kutools. ** Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Count the Number of Words in a Cell or a Range in Excel Office 365!!](https://geekexcel.com/count-the-number-of-words-in-a-cell-or-a-range-in-excel-office-365/)
- [Add Hours/Minutes/Seconds to a Datetime in Excel Office 365!!](https://geekexcel.com/add-hours-minutes-seconds-to-a-datetime-in-excel-office-365/)