How do I remove duplicate records in an excel spreadsheet?

Removing duplicates can help you track the correct numbers of your contacts, but removing them 1 by 1 can be a pain especially if you have a large contact list.

Below, you'll learn how to use Excel to clean your list.

Remove Duplicates

To remove duplicates from your list, you'll need to press Shift button on your keyboard and click column letter A to the letter that has the last field or press ctrl+a to select all.Open Microsoft Excel.

With the appropriate columns highlighted, click Data in the navigation and click Remove Duplicates.

Before:

After:

Remove duplicates and originals from a list

First you will want to re-format your duplicate cells:

Then sort your document by cell colour to segment your list into duplicate and non-duplicate cells:

Once your list has been sorted by cell colour, you can easily select and delete duplicate contacts from the list.

Whats Next?

• Spreadsheeto have a great article for How to remove blank rows in Excel
• For advance rules, please refer to Microsoft's guide here.