Remove Duplicates Rows in Excel 2013

Introduction

In this article we explain how to remove duplicate rows from large data sheets in Excel 2013. A duplicate row in a list is one where all values in one row are an exact match of all the values in another row. In a large Excel data sheet it's very difficult to find and delete duplicate rows from a record. To do that Excel provides a "Remove Duplicates" property by which you can easily delete duplicate rows from large data sheets.

How to delete duplicate rows from Excel data sheets

Step 1

Open an Excel worksheet and select a record from where you want to remove duplicate rows.

Select-Record-Excel2013.jpg

Step 2

In the "Data" tab click on "Remove Duplicates".

Remove-Duplicate-Excel2013.jpg

Step 3

A Remove Duplicate window will be shown. Select the column name to be used to determine whether to remove duplicate rows. And click "OK".

Remove-Dialogbox-Excel2013.jpg

Step 4

After doing that a dialog box will be opened that shows how many duplicate records have been deleted and how many records remain.

Count-Record-Excel2013.jpg

Step 5

Now go to your records. You will see that duplicate records have been deleted.

Removed-Rows-Excel2013.jpg

Up Next
    Ebook Download
    View all
    Learn
    View all