Delete Duplicate Rows From Microsoft Excel 2007

Working with a large number of records in excel have a very common issue, i.e. duplicate rows and values. When Microsoft Excel imports or combines many records, it may create duplicates. This is quite natural. This article helps you to learn how to remove duplicate records easily from a huge excel database or worksheet.

Following these steps you can easily learn about it;

First we will learn how to identify the duplicate value cells

Here we have a sample data sheet, where we can see few students name, class, roll number and marks

Now we need to identify the Marks which are duplicates.

At first we need to select the Marks column then we need to click on Conditional Formatting under the Styles menu. Click on the drop down menu and select Highlight Cell Rules and then Duplicate Values.

You will get popup windows named Duplicate Values. Here you can select the color format as per you and it will highlight the cells which have duplicate values.

Now we will see how to identify and delete duplicate value cells

We have another sample data sheet where same data and same line appear more than once.

Select the whole sheet and Go to Data tab

Click on Remove Duplicates under Data Tools

A new popup window comes up named Remove Duplicates, Click on Ok

It will remove the duplicate values and keep only the unique