Microsoft Excel has many features, sometimes people would like to find and remove the duplicate values. But this process is not easy if the file data more then thousands of rows. This will not be done by the manual process must be using an automated process. Fortunately, Microsoft Excel has the features to find and remove duplicate values.


Find and Remove the duplicate Value from Excel

Following setups guide you to remove the duplicate value from excel:

  1. Open the excel file what you would like to remove the duplicate values
  2. Click on the Home Tab and go to Conditional Formatting > Highlight Cells Rules > Duplicate values
  3. remove-duplicate-01

  4. In the duplicate values, window select the color what you would like to show the duplicate data and click OK
  5. remove-duplicate-02

  6. It will show the duplicate values in your excel files
  7. If you need to remove those duplicate values then go to Data Tab > Remove Duplicates in the “Data Tools” section.
  8. remove-duplicate-03

  9. Remove Duplicate window will be open select the column what you would like to remove the duplicate values and Click OK


Now selected duplicate values will be removed from your excel sheet. Please be note If you select all rows it will remove only the all columns duplicate values. If you select any particular column it will remove the particular column duplicate values.



If you liked this article, please subscribe to our YouTube channel for Technology videos.
The following two tabs change content below.
Jey Ganesh is a Tech Blogger of, Here you can find Technology, Internet and Mobile solutions. You can also engage with techThagavel via RSS, Newsletter. Email:

Comment :