ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software»
  • Computer Software»
  • Office Software Suites»
  • Microsoft Office

Tutorial - MS Excel - How to Remove Duplicates from an Excel Sheet

Updated on May 18, 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 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.

© 2012 Petite Hubpages Fanatic


    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

      Petite Hubpages Fanatic 4 years ago from Hyderabad, Andhra Pradesh

      Thank you expertscolumn & Leeba

    Click to Rate This Article