Normally when we have dirty data, we tend to get a lot of duplicates. But in Excel it is very easy to spot the duplicates for your data cleanup!

Here is our sample list of words, you can see it has a lot of duplicates:

I explain how you can do this below:


STEP 1: Select your list of words / data:


STEP 2: Go to Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values


STEP 3: You can select the formatting that you want. For our example, we selected Green Fill with Dark Green Text.

Click OK.


You will now see the magic happen, all of the duplicate values are now highlighted in your Excel worksheet!


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

How to Unhide Columns in Excel We normally use "helper columns" to do calculations in our Excel worksheet.  These "helper columns" are for our own internal use and we usually hide these columns so no one else can see them, like our evil boss! But once we are done with presenting our Excel worksheet to our e...
CTRL + BACKSPACE: Go Back to the Active Cell Say that you click in cell A4 within your Excel worksheet and then you scroll all the way down to the bottom of the page to check on a number in row 20,187. The quickest way to get back to your active cell in A4 is to press the CTRL + BACKSPACE on your keyboard! Watch below...