This tutorial teaches you how to find duplicates in MS Excel and how to Delete Duplicate Values in MS Excel. An easy way to find duplicate rows in Microsoft Excel and remove duplicates in MS Excel. How to find duplicates in MS Excel 1. Select the cell range with data. To select, click the top left cell of the range, and then drag to the bottom right cell. 2. On the Home tab, click Conditional Formatting, Highlight Cells Rules, Duplicate Values… 3. Select a formatting style and click OK. Please note that in the Duplicate Values box, Duplicate is selected

Source