How to delete duplicate rows in Excel 2013

9 sec read

  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.

Last Updated On April 07, 2018

Leave a Reply

Notify of