How to Remove Duplicates From an Excel Sheet

Updated on September 15, 2017
nehanatu86 profile image

Neha is a software professional who specializes in ServiceNow Customization and Implementation. She likes writing tutorial articles.

Removing duplicate values from an Excel worksheet is a simple five-step process.


1. Assume these are the set of values you have in your Excel sheet.

2. Go to the Data tab in the menu header and click on Remove Duplicates.

3. Select the columns which should be checked for duplicate values and click OK.

4. Duplicate values (if any) will be removed from the selected column. A pop-up message is displayed which specifies the number of duplicate values found and the number of unique vales remaining. Click OK.

5. The resulting set of values is free from any duplicate data.

© 2012 Petite Hubpages Fanatic


    0 of 8192 characters used
    Post Comment

    • nehanatu86 profile image

      Petite Hubpages Fanatic 5 years ago from Hyderabad, Andhra Pradesh

      Thank you expertscolumn & Leeba

    • leeba ann varghes profile image

      Leeba Ann Varghese 5 years ago from India

      simple and easy explanation..good job

    • expertscolumn profile image

      Stanley Soman 5 years ago from New York

      so easy and neat. Thanks for the simple yet thorough tutorial.