How to Find Duplicates in Microsoft Excel

Quick summary

You can find duplicates in Microsoft Excel in just a few clicks using the built-in Conditional Formatting tool, which automatically highlights duplicate values across your selected cells without any formulas.

Steps

1. Open Microsoft Excel and click the select-all cell at the top-left corner of your table to highlight all cells.
2. Go to the Excel ribbon and click Conditional Formatting.
3. Select Highlight Cells Rules from the dropdown menu.
4. Click Duplicate Values to apply the rule.
5. Excel will automatically highlight all duplicate entries in your selected range.