If you need to clean up your Excel sheet and spot the duplicates in the data then you are at the right place. Here I’m going to tell you how to find duplicates in Excel.
These are the steps given below to know how you can do this in your Excel sheet:
STEP1: Select Your Data
Firstly, you need to select your list of words / data:
STEP2: Highlight Your Duplicate Values
After selecting the data follow this:
Go to Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values
here for my example, I’m selecting Light Red Fill with Dark Red Text, you can also select the formatting that you want.
To continue, click OK.
There you got all of the highlighted duplicate values in your Excel worksheet!