Follow these steps to remove duplicate records in Excel:

1. In the top menu of Excel, select the Data tab
2. Select Remove Duplicates
3. In the Remove Duplicates dialog box, select the column(s) you wish to remove duplicates from, and select OK