How to Remove Duplicates in Excel: A Step-by-Step Guide - Blog | Excelly-AI
01 April 2023

How to Remove Duplicates in Excel: A Step-by-Step Guide

This article provides a step-by-step guide on how to remove duplicates in Excel

Have you ever found yourself working with a large amount of data in Excel and realized that there are duplicates in your spreadsheet? Duplicates can make it difficult to work with your data and may even cause errors in your calculations. Luckily, Excel provides a simple way to remove duplicates from your data. In this guide, we’ll walk you through the process of removing duplicates in Excel, step by step.

Step 1: Select Your Data

The first step in removing duplicates in Excel is to select the data you want to work with. Make sure to select all the columns that contain data you want to check for duplicates.

Step 2: Open the Remove Duplicates Dialog Box

Once you have selected your data, click on the “Data” tab in the Excel ribbon, and then click on the “Remove Duplicates” button. This will open the “Remove Duplicates” dialog box.

Step 3: Choose the Columns to Check for Duplicates

In the “Remove Duplicates” dialog box, you will see a list of columns in your selected data. By default, all columns are selected. If you only want to check for duplicates in specific columns, uncheck the boxes next to the columns you don’t want to check.

Step 4: Remove Duplicates

After you have chosen the columns to check for duplicates, click the “OK” button to remove the duplicates from your data. Excel will display a message telling you how many duplicate values were removed.

That’s it! You have successfully removed duplicates from your data in Excel.

Tips to Keep in Mind When Removing Duplicates in Excel

  • Always make a backup of your data before removing duplicates, just in case you accidentally delete important data.
  • If you’re not sure which columns to select, you can select all the columns in your spreadsheet and let Excel automatically remove duplicates.
  • Excel will remove all duplicate values, including the first occurrence of a duplicate value. Make sure this is what you want before removing duplicates.


Removing duplicates in Excel is a simple process that can save you time and prevent errors in your calculations. By following the steps outlined in this guide, you can easily remove duplicates from your data and ensure that you’re working with clean, accurate data. Remember to always make a backup of your data and double-check that you’ve selected the correct columns before removing duplicates. Happy data cleaning!


excel tips duplicates