How to remove duplicate records in Excel

Home > Search > How-to

Follow these steps to remove duplicate records in Excel:

  1. In the top menu of Excel, select the Data tab
  2. Select Remove Duplicates
  3. In the Remove Duplicates dialog box, select the column(s) you wish to remove duplicates from, and select OK


Add a Comment

We will never share your name or email with anyone. Enter your email if you would like to be notified when we respond to your comment.

Please enter in the box below so that we can be sure you are a human.