Excel comes with a built-in tool that makes cleaning your data quick and easy. Here's how it works. When you have duplicate data that you want to remove from a single column in your dataset ...

Select columns from which you want to remove duplicates. Click OK. Excel displays a message showing the number of duplicate ...

Change the scope to This Worksheet to see all the rules and select the relevant rule to edit or delete. Sometimes, it's more practical to highlight duplicates across two Excel columns instead of ...