How to Delete Duplicates in Excel

In this video tutorial we will show you how to delete duplicates in excel.
Open the excel document you want to edit. Select the part of the text where you want to find duplicates. Go to “Data” tab, click on “Remove Duplicates” button.



Click on Remove Duplicates

Select the column where you want to remove duplicates and click “ok”. Now you can see how much duplicate values were found and removed.
Select column to remove duplicates

Related posts:

  1. How to Delete Blank rows in Excel
  2. How to remove the search history from Windows Explorer
  3. How to uninstall application in Windows 8
  4. How to delete Windows.old in Windows 8
Posted on January 10, 2013 by . This entry was posted in Basics and tagged , , , , . Bookmark the permalink.