Tutorials · 1:20 min read

How to Find and Remove Duplicates in Excel

Published · June 05, 2019
Justin Pot

Whether it's an import error or someone accidentally pasting something twice, duplicate data makes your spreadsheets less useful. Here's how to find duplicates in Excel, so you can delete them yourself, and how to find and delete duplicates in one quick motion.

How to Find Duplicates in Excel

If you simply want to find duplicates, so you can decide yourself whether or not to delete them, your best bet is highlighting all duplicate content using conditional formatting.

Select the columns you want to check for duplicate information, and click Home > Highlight Cell Rules > Duplicate Values.

You will be asked which color scheme you'd like to use for the highlighting.

Click OK, and all duplicate rows in your selected columns will be highlighted.

You can now review the data and decide yourself whether to delete anything that's redundant.

How to Remove Duplicates in Excel

If you'd like to delete duplicates in Excel without manually reviewing them first, you can. Select the data you'd like to remove duplicates from, then click Data > Remove Duplicates.

You will be asked which columns you'd like to include in your search for redundant data. This is useful if there is one column that wouldn’t include any duplicate data.

Click OK and Excel will find and delete all rows containing duplicate data.

Want to learn more Excel tricks? Check out our Excel overview for updates, tutorials, and ways to integrate Excel with thousands of other apps.

Related Posts

See All

How to Use VLOOKUP in Excel Online