One of the easiest ways to locate duplicate data in Excel is to use conditional formatting. Here's how. Step 1: Select the portion of your data where you want to locate duplicates.