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:

removedupss.png

After:

removedupsuccess.png

 

Whats Next?

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.