- 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.
Image Credits: Photo by Isis França on Unsplash.