Highlight duplicates in excel

Highlight duplicates in excel

Highlight duplicates in excel

In this Microsoft Excel blog post we will tell you a very important trick, which you can easily use to mark duplicate values ​​in thousands of data.

How to find duplicates in excel


As you see in the picture, the names of some places are mentioned in column A, it may have more than one name for some places.

To find out, we will use the conditional formatting option.

The conditional formatting option is available in the Home tab.

First, select the data in which you want to know the duplicate values.



Then in the conditional formatting option, there are first highlight cell rules then Duplicate values options.


Then Excel will ask you what color to highlight the duplicate values in. If you need to change the color, otherwise, turn it ok, it will highlight the duplicate values.






Understanding Microsoft Excel's trick will make it easier for you to know the duplicate values and the following questions will be solved.

Highlight duplicates in excel
How to find duplicates in excel
How to find duplicate values in excel
How to highlight duplicate values in excel
How to find duplicate entries in excel
How to find duplicate data in excel
How to find duplicate records in excel

Post a comment

0 Comments