How to remove duplicates in Microsoft Excel

How to remove duplicates in Microsoft ExcelMicrosoft Excel is a very powerful document processing tool especially when it comes to making reports, calculations and storing a database for any particular project. However, at times, while creating an excel spreadsheet people often face challenges and make errors due to duplicate values in your data.

Thankfully, Microsoft Excel comes with a feature that allows users to find duplicate values and remove them. Follow our step-by-step guide to find and remove duplicate values in Excel spreadsheets.

Do note that deleting duplicates will permanently remove these values.

How to find and remove duplicates in Excel
1.
Select the cells for which you want to look for duplicate values

2.
Click on Home and head to Conditional Formatting option

3.
Here, choose Duplicate Values option under Highlight Cells Rules section

4.
Now, pick the formatting you want to apply for duplicate values and click on Ok

5.
Once the values are highlighted, select the range of cells that has duplicate values

6.
Click on Data and select Remove Duplicates and check or uncheck the columns where you want to remove the duplicate values.

7.
Click Ok to apply the changes