Tuesday, January 21, 2020


In this lesson, we will teach you how to find and highlight duplicate data in excel worksheet.
May be duplicate data can be useful in sometime but often duplicate data makes harder to understand and sometimes create confusion to the readers of those data and bring unclear meaning.
But, in MS-Excel, you can easily find and highlight duplicate data of your worksheet with some simple steps.
By using, conditional formatting (one of Excels most useful function) to find and highlight duplicate data. That’s the way, you can review the duplicates and decide if you want to remove them.

The task is very simple. Just follow the below steps and at last, we use some demo data and screenshots so that you can clearly understand the thing. Have a look at those images and practice with those sample data or your own data to master the topic.

Without furthermore delay, let’s proceed, 

At first, select the data you assigned.

select your data in the worksheet

Go to the Home tab, click on the Conditional Formatting option.

Highlight Cell Rules Go to this option (as shown in the image) and click on the 'Duplicate Values' option from here.

The default screen will come infront of you, 

but, you can change styles from the below drop-down box.

and, finally you can get the below image by selecting 'Red Text' with Duplicate data 

exist in the worksheet.

Isn’t it very much easy to find and highlight duplicate data in your Excel worksheet! So, for more easy MS-Excel tutorial stay with tutorialabc.com and best of luck to those enthusiasts who are keen to learn easy and useful things from us.

No comments:

Post a Comment