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

Tutorial – MS Excel – How to Highlight Duplicate Values in Microsoft Excel without Deleting them

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.

Sometimes you may not want to remove the duplicate values altogether from MS Excel but may want to highlight them anyway. Here's a step-by-step tutorial to highlight duplicate values in Microsoft excel without deleting them.

Steps:

1. Assume these are the values you have in your excel sheet and you want to highlight the duplicate values in the list.

MS Excel - Dummy Values
MS Excel - Dummy Values

2. Select all values.

MS Excel - Select Values
MS Excel - Select Values

3. Go to Home menu > Conditional Formatting > Highlight Cells Rules > Duplicate Values…

MS Excel - Highlight duplicate values
MS Excel - Highlight duplicate values

4. Click on ‘Duplicate Values…’ a menu will open up.

MS Excel - Highlight duplicate values
MS Excel - Highlight duplicate values

5. From the menu drop down list, you can choose to highlight either 'duplicate' or 'unique' values from the list.

MS Excel - Highlight duplicate or unique values
MS Excel - Highlight duplicate or unique values

6. You can also choose what kind of formatting you wish to have.

MS Excel - Highlight duplicate values
MS Excel - Highlight duplicate values

7. Select the desired options and click on “Ok”.

MS Excel - Highlight duplicate values
MS Excel - Highlight duplicate values

8. The final result will look like this.

MS Excel - Duplicate values highlighted
MS Excel - Duplicate values highlighted

© 2012 Petite Hubpages Fanatic

Comments

    0 of 8192 characters used
    Post Comment

    No comments yet.