Remove Excel Duplicates

This Excel tutorial teaches you how to remove duplicate rows from a sheet. The example file (available for download) contains three identical rows.

When removing duplicate rows, Excel removes all the identical rows except for the first identical row found (In this example row 2).

1. Open the accompanied Excel file, and click any single cell within the data range.

2. On the Data tab, click Remove Duplicates.

The following dialog box appears.

3. To remove duplicate rows, leave all checkboxes checked and click on OK.

Result:

To remove rows with identical values in certain columns, simply check the specific columns.

4. For example, remove rows with the same Last Name and Quarter.

Note: all other rows have a unique combination of Last Name and Quarter.

5. Check Last Name and Quarter and click on OK.

Result:

Did you like this free Excel tutorial? Show your appreciation, vote for us.

Thank you very much! We've got many more free Excel tutorials for you. Read on, learn, and enjoy!

Go to Top: Remove Excel Duplicates    |    Go to Next Tutorial: Excel What-If Analysis