Once you are done with the changes in the Remove Duplicates dialog, click on the OK button to find and remove duplicates from the selected columns. My example worksheet has headers, so I have selected the “My data has headers” check box and the example worksheet has duplicate rows in the Fruits column, so I have selected the column “Fruits”. Remember that you should select at least one column that contains duplicates from the columns list in order to remove duplicates.
Select the list of columns by selecting the check box before the column name in the Columns list.Select My data has headers check box if your data has headers.From the Remove Duplicates dialog select the following options: Excel – Remove Duplicates dialogįrom my example worksheet mentioned above, I have selected the column “Fruits” here it displayed the column “Fruits”. It will display the Remove Duplicates dialog to allow to select a list of columns. Click on the Remove Duplicates icon which is under the Data Tools group. Click on the Data menu, it will display Data ribbon controls. For eg: my worksheet has only one column Fruits and I have selected the column “A”. Open your Excel worksheet and select the range of columns from where you want to find the duplicate entries. Fortunately, Microsoft Excel provides a feature to find and remove the duplicate rows within the Excel Worksheet. Most of the time while dealing with the data in Microsoft Excel it is required to find the duplicate rows and remove them.