Head to Excel Home -> Search and select Replace. Enter a typo in the ... There is a high probability that your workbook might have duplicate data or entries without your knowledge.

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