How to delete duplicate rows in Excel 2013

H

How Can We Help?

How to delete duplicate rows in Excel 2013

  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.

About the author

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.

About Author

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.

Follow Me