Remove Duplicate Rows in Excel


If you are using Microsoft Office Suite you will have a bit of an advantage because there is a built in feature for finding and deleting duplicates.

STEP1: Begin by selecting the cells you want to target for your search. In this case, we will

select the entire table by pressing “Control” and “A” at the same time (Ctrl + A).

STEP2: Once you have successfully selected the table, you will need to click on the “Data”

tab on the top of the screen and then select the “Remove Duplicates” function as

shown below.

STEP3: Once you have clicked on it, a small dialog box will appear. You will notice that the

first row has automatically been deselected. The reason for this is that the “My data

has headers” box is ticked.

STEP4: In this case, we do not have any headers since the table starts at “Row 1.” We will

deselect the “My data has headers” box. Once you have done that, you will notice

that the whole table has been highlighted again and the “Columns” section changed

from “duplicates” to “Column A, B, and C.”

STEP5: Now that the entire table is selected, you just press the “OK” button to delete all

duplicates. In this case, all the rows with duplicate information except for one have

been deleted and the details of the deletion are displayed in the popup dialog box.


About Author

Comments are closed.