ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Tutorial - MS Excel - How to remove duplicates from an excel sheet

Updated on August 22, 2016

Removing duplicate values from an excel worksheet is a simple 5 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. Resulting set of values is free from any duplicate data.


    0 of 8192 characters used
    Post Comment

    • expertscolumn profile image

      Stanley Soman 4 years ago from New York

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

    • leeba ann varghes profile image

      Leeba Ann Varghese 4 years ago from India

      simple and easy explanation..good job

    • nehanatu86 profile image

      nehanatu86 4 years ago from Hyderabad, Andhra Pradesh

      Thank you expertscolumn & Leeba

    Click to Rate This Article