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.

Then, click "OK" when Excel reminds you that you're about to replace some data. To duplicate the contents of a cell, row, or column where data is already entered, select the relevant cell ...