Duplicate entries can throw off your calculations and make your lists unreliable. Use Excel’s built-in tools to find duplicates: Go to the Home tab Click Conditional Formatting > Highlight Cells Rules ...