Find and Remove Duplicates in Excel! (2 Extremely easy tricks!)

Find and Remove Duplicates in Excel! (2 Extremely easy tricks!) Microsoft Excel

Duplicate information might be useful sometimes, but in most of the cases, it makes understanding of our data hard and not usable. Here we will take a look at how to easily spot Duplicate Data and Delete it from our Spreadsheet!

Highlight Duplicate Cells

First, we are going to look at How to Highlight Duplicate Cells in order to find them easily. This is an easy 3 step process:

  1. We have to select all the cells we want to Analyze.
    Find and Remove Duplicates in Excel! (2 Extremely easy tricks!) Microsoft Excel
  2. Secondly, we will click on Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.Find and Remove Duplicates in Excel! (2 Extremely easy tricks!) Microsoft Excel
  3. A window will pop up called Duplicate Values, here next to the values with we can pick the formatting we want and then hit OK.
    Find and Remove Duplicates in Excel! (2 Extremely easy tricks!) Microsoft Excel

As you can see most of the data in our Example is Duplicate. Now we can decide whether or not we need those duplicates.

Find and Remove Duplicates in Excel! (2 Extremely easy tricks!) Microsoft Excel

Remove Duplicate Cells

Erasing Duplicate rows is as easy as highlighting them. Again we will go through 3 simple steps:

  1. First, select cells that has duplicate values we want to remove
  2. Secondly, we click on Data tab and then Remove Duplicates.
    Find and Remove Duplicates in Excel! (2 Extremely easy tricks!) Microsoft Excel
  3. A window will pop up, here we will check the columns where we want to remove the duplicates. After that we hit OK.
    Find and Remove Duplicates in Excel! (2 Extremely easy tricks!) Microsoft Excel
    Find and Remove Duplicates in Excel! (2 Extremely easy tricks!) Microsoft Excel

 

Leave a Reply