How to Find Duplicates in Microsoft Excel
Here's how to do it:
- 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.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it