- Select the range of cells in which to delete duplicates.
- Click on the Data tab and then on Remove Duplicates under the Data Tools section
- Select the relevant columns that contain duplicates and click on OK
- All duplicates have now been deleted.
How to delete duplicate rows in Excel 2013
9 sec read