How to Find Duplicates in Microsoft Excel

‍

‍

Here's how to do it:

‍

1. Open Microsoft Excel and click on the highlight all cell at the top left corner of the table.
2. Go to the Excel ribbon and click on "Conditional Formatting."
3. Select "Highlight Cells Rules."
4. Click "Duplicate Values."
5. Excel will highlight the duplicate entries as shown below.