1. Select the range of cells in which to delete duplicates.

  2. Click on the Data tab and then on Remove Duplicates under the Data Tools section

  3. Select the relevant columns that contain duplicates and click on OK

  4. All duplicates have now been deleted.