How to quickly find duplicates in Excel

Have you ever had a long list of items and you need to quickly identify which ones are duplicates?  Thankfully, Excel’s Conditional Formatting feature makes it easy to quickly find duplicates in Excel.

Open your Excel file and highlight the data that may have duplicates.

List of movies in Excel, some of which are duplicates.

From the ribbon, select Home (tab), Styles (group), Conditional Formatting (icon), Highlight Cells Rules (menu), Duplicate Values…

Use the conditional formatting option to find duplicates in Excel

Optional:  From the second drop down choose a format for highlighting duplicate values, then click OK.

Use this dialog box to format the duplicate values

The duplicates should now appear in the format you chose.

List of movies, with the duplicates now highlighted

We hope you have found this trick useful.  In a future blog post we will discuss how to use another Excel feature to easily remove duplicates from a list.

You can learn more time-saving tips twice a month by subscribing to our online newsletter.  You can sign up at

This entry was posted in Excel and tagged , , , . Bookmark the permalink.

Leave a Reply