How to Search Excel 2007 for Duplicates

In this video tutorial we will show you how to search excel for duplicates


In order to search the duplicates in excel, open your document. Select the data in the document. Click on “Conditional Formatting” in the “home” tab. In the pop-up menu go to “highlight cells rules”, then choose “duplicate values”.

Open the Duplicate Values dialogue

In the “duplicates values” window select a color to highlight duplicates with and press “ok”.

Now all your duplicates in the excel document are found and highlighted.

Found and highlighted all duplicates