How to Remove Duplicates in MS Excel

Remove Duplicates

This example teaches you how – removing duplicates in Excel

Click any single cell inside the data set.
On the Data tab, click Remove Duplicates.
Leave all checkboxes checked and click OK.
Result. Excel removes all identical rows (blue) except for the first identical row found (yellow).

Removing duplicates in Excel, follow these steps:

Select the range of cells from which you want to remove duplicates.
Click on the “Data” tab in the top menu bar.
Click on the “Remove Duplicates” button in the “Data Tools” section.
In the “Remove Duplicates” dialog box, choose the columns that you want to use to identify duplicates. By default, all columns are selected.
Click the “OK” button. Excel will remove any duplicate rows and display a message indicating how many duplicates were removed.
Click the “OK” button in the message box to close it.

Your duplicates should now be removed. Note that this process permanently deletes any duplicate rows in your worksheet, so make sure you have a backup copy of your data if necessary.

Explore our Excel Training Courses here and to read our blogs on MS Excel please click here.