How to Find Duplicates in Microsoft Excel
- George Apostolov
- 05 Sep 2025
Guide
Open Microsoft Excel and click on the highlight all cell at the top left corner of the table.
Go to the Excel ribbon and click on "Conditional Formatting."
Select "Highlight Cells Rules."
Click "Duplicate Values."
Excel will highlight the duplicate entries as shown below.
Create your first interactive demo in minutes
No credit card required • Start building today
