How to Prevent Duplicate Entries in a Column in Excel Office 365?
Tags: kutoolsexceltutorial, stepstopreventduplic, kutools
Published: 2020-10-14 11:49:08

---
title: How to Prevent Duplicate Entries in a Column in Excel Office 365?
published: true
date: 2020-10-14 08:52:16 UTC
tags: KutoolsExcelTutorial,StepstoPreventDuplic,Kutools
canonical_url: https://geekexcel.com/how-to-prevent-duplicate-entries-in-a-column-in-excel-office-365/
---

In this article, we are going to explore how to **Prevent Duplicate Entries in a Column in Excel Office 365** using **Kutools.** Let’s get into this article!! 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.
## Prevent Duplicate Entries in a Whole Column:

To prevent duplicate entries in a whole column, do the below steps.

- First, you need to **select any one of the columns** from your worksheet that you want to prevent duplicate entries.

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

- Then, on the **Kutools Tab, select** the **Prevent Typing** option, **choose** the **Prevent Duplicate** option from the drop-down list.

![Select Prevent Duplicate option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Prevent-Duplicate-option.png)<figcaption id="caption-attachment-15727">Select Prevent Duplicate option</figcaption>

- Now, **Kutools for Excel dialog box** will pop-out to remind you that it will remove data validation from your selected range to continue the operation.
- You need to **click** the **Yes** button to continue the process.

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

- Again, a **prompt box** will pop-out to tell you the selected range has been prevented typing duplicates.
- **Hit** the **OK** button.

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

- If you try to insert the same data in the same column, it will throw a warning message as shown in the below image.

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

### Note:

- If you forget to select a column before applying this feature, then automatically it will take a column of the currently active cell and set to prevent duplicates entries.

## Steps to Prevent Duplicate Entries in a Range of a Column:

If you want to prevent duplicate data in a range of a column, do as follows.

- You need to **select a range** in the column in which you want to avoid duplicate entries.

![select a range in a column](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-16.png)<figcaption id="caption-attachment-15731">select a range in a column</figcaption>

- Then, on the **Kutools Tab, select** the **Prevent Typing** option, **choose** the **Prevent Duplicate** option from the drop-down list.

![Select Prevent Duplicate option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Prevent-Duplicate-option.png)<figcaption id="caption-attachment-15727">Select Prevent Duplicate option</figcaption>

- Now, **Kutools for Excel dialog box** will pop-out to remind you that it will remove data validation from your selected range to continue the operation.
- You need to **click** the **Yes** button to continue the process.

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

- Again, a **prompt box** will pop-out to tell you the selected range has been prevented typing duplicates.
- **Hit** the **OK** button.

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

- If you type any same data in the selected range, it will show the warning message as given in the below steps.

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

From the above image, you can see the warning pop-up appears on the screen. The pop-up shows us the value has been entered is not valid.

## Wrap-Up:

In this article, you can clearly understand the steps to **Prevent Duplicate Entries in a Column in Excel Office 365** using **Kutools.** Give your **suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Auto Resize Comment Boxes to Fit the Contents in Excel Office 365!!](https://geekexcel.com/auto-resize-comment-boxes-to-fit-the-contents-in-excel-office-365/)
- [Convert Cell Formulas to Text Strings in Excel ](https://geekexcel.com/how-to-convert-cell-formulas-to-text-strings-in-excel-office-365/)