How to Find Duplicates in Excel (Fast & Easy)
Need to spot repeated data in your spreadsheet without deleting it? In this video, I’ll show you how to find duplicate values in Excel using a simple and beginner-friendly method.
Using Conditional Formatting is the safest way to identify duplicates because it highlights the data in color, allowing you to review everything before taking action. This is a must-know skill for anyone managing large contact lists, inventory, or financial reports in 2026.
What you’ll learn in this video:
✅ The Selection Shortcut: How to quickly select your entire dataset using Ctrl + A.
✅ Conditional Formatting: Step-by-step instructions to trigger the "Highlight Cells Rules."
✅ Custom Colors: How to change the highlight color to make duplicates stand out.
✅ Specific Column Search: How to find duplicates in just one column (like Email or ID) instead of the whole sheet.
✅ Data Safety: Why this method is better than jumping straight to deleting.
This method works in all modern versions of Excel, including Excel 365 and Excel 2021. Once you know how to find duplicates, you’ll have full control over your data cleaning process.
If this quick Excel tip helped you, please Like the video and Subscribe for more search-based tech tutorials!