---
title: "How to remove duplicates in Excel"
description: "Here's how to remove duplicates in Excel. Plus, learn how to find duplicates in Excel so you can decide if you should remove them. "
image: "https://images.ctfassets.net/lzny33ho1g45/2S0H6GfYCc2HqJb0tQIvPQ/f188f5eb70a93984e9b42153d257e622/excel_hero.jpg"
---

# How to remove duplicates in Excel

Here's how to remove duplicates in Excel. Plus, learn how to find duplicates in Excel so you can decide if you should remove them. 

Raise your hand if you've ever entered data into Excel and immediately asked yourself, "Wait. Didn't I already type that?" Whether it's an import error or [human error](https://zapier.com/blog/excel-errors/), duplicate data makes your spreadsheets less useful. 

Here's how to find duplicates in [Excel](https://zapier.com/blog/excel-online-guide/), so you can delete them yourself. Plus, I'll show you two ways to remove duplicate rows in one fell swoop. 

- [How to remove duplicates in Excel](#remove-duplicates)
- [How to find duplicates in Excel](#find-duplicates)

## How to remove duplicates in Excel

Here are two ways to automatically remove duplicates in Excel (without having to manually review them first). 

### Use the remove duplicates feature in Excel 

1. Click any cell that contains data.
2. Click the **Data** tab, and then select **Remove Duplicates**_. _

3. From the _Remove Duplicates_ window that appears, select which columns you'd like to include in your search for redundant data. Click **OK**. (The _Remove Duplicates_ tool will permanently delete duplicate data, so it's a good idea to copy the original data to another worksheet for backup.)

4. Excel will let you know how many duplicate values were removed. Click **OK**.

### Use the UNIQUE function in Excel 

In Excel, the UNIQUE function returns unique values (data that's not duplicated) from a list or range. The only caveat is that this will not _replace_ your existing data. It exists within the same spreadsheet as the original source of data. 

To get a unique list of values, select an empty column of your spreadsheet. Then input the UNIQUE function using the cell range you want to scan for duplicates, leaving behind only unique values. For example, `=UNIQUE(A2:C14)`. 

## How to find duplicates in Excel

If you simply want to _find_ duplicates in Excel, so you can decide whether or not to delete them, your best bet is to highlight all duplicate content using conditional formatting.

1. Select the data you want to check for duplicate information. Then, from the _Home_ tab, select **Conditional Formatting** > **Highlight Cell Rules** > **Duplicate Values**_.  _

2. From the _Conditional Formatting _window that appears, click the dropdown menu under _Format with _to select the color scheme you'd like to use for highlighting duplicates. Then click **Done**. (Tip: Choose a high contrast color scheme, such as _Light red fill_, to improve readability.)

3. You can now review the duplicate data and decide whether you need to delete any redundant information.

## Automate Microsoft Excel 

If you're removing duplicate data in Excel due to human error, you may find yourself questioning the accuracy of everything else in your spreadsheet. 

Use Zapier to [connect Excel](https://zapier.com/apps/excel/integrations) with the rest of your apps, so you can automate your spreadsheet-related tasks and remove the stress of human error. Learn more about [how to automate Excel](https://zapier.com/blog/automate-microsoft-excel/), or get started with one of these workflows. 

**Related reading:**

- [How to remove duplicates in Google Sheets](https://zapier.com/blog/remove-duplicates-google-sheets/)
- [Popular ways to automate spreadsheets](https://zapier.com/blog/automate-spreadsheets/)
- [How to enter a formula without a function in Excel](https://zapier.com/blog/how-to-enter-formula-without-function)
- [How to make an Excel waterfall chart](https://zapier.com/blog/excel-waterfall-chart)
- [How to calculate time differences in Excel](https://zapier.com/blog/calculate-time-difference-in-excel)
- [How to convert Excel to Google Sheets](https://zapier.com/blog/convert-excel-to-google-sheets)

_This article was originally published in June 2019 by Justin Pot. The most recent update was in May 2024._