Microsoft Office

How to delete duplicate rows in Excel 2013

Written by Ian Carnaghan · 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
Written by Ian Carnaghan
I am a software developer and online educator who likes to keep up with all the latest in technology. I also manage cloud infrastructure, continuous monitoring, DevOps processes, security, and continuous integration and deployment. Profile

Leave a Reply

Notify of