How to Find Duplicates in Excel: To find duplicates in Excel, highlight the column or range of cells you want to check. Then, go to the "Conditional Formatting" option in the "Home" tab and select "Highlight Cells Rules." Choose "Duplicate Values" and select the formatting you prefer.