The Perfect Guide to Learning How to Highlight Duplicates in Excel

Highlight Duplicates in Excel is the most frequently asked question in the data analytics interviews. Highlighting Duplicate cells in excel can be done within a few simple clicks, no matter how voluminous the data is. This article on Highlight Duplicates in Excel will help you master the most useful procedure used in data analysis.

Become an AI-powered Business Analyst

Purdue Post Graduate Program in Business AnalysisExplore Now
Become an AI-powered Business Analyst

How to Highlight Duplicates in Excel?

Duplicate entries in the dataset are a common problem in the data cleaning procedures. Sometimes you might have to eliminate duplicates, and in a few situations, you might have to highlight the duplicates depending on the requirement. This article will help learners how to highlight duplicates in excel in a few simple clicks, which requires us to follow the below steps.

  • Step 1: Select the entire data or all columns in which you want to highlight the duplicate values. A sample dataset is shown below.


  • Step 2: Navigate to the Home option in the toolbar. The option of Conditional Formatting will be visible. Select conditional formatting. You will see a dropdown menu. Select the highlight option. In the next dropdown menu, select the Highlight duplicate values option as shown below.


  • Step 3: Choose the color you want to highlight the duplicate cells with and select ok as shown below.


Become an AI-powered Business Analyst

Purdue Post Graduate Program in Business AnalysisExplore Now
Become an AI-powered Business Analyst

  • Step 4: The final result is generated by Microsoft excel after highlighting the duplicate cells with the color chosen. The result is shown below.


With this, we have reached the end of this article on "How to Highlight Duplicates in Excel."

Kick-start your career growth story with our PGP in Business Analysis. Get a chance to master Excel, Tableau, and Python tools. Start learning now!

Next Steps

How to remove blank rows in excel can be your next milestone in mastering excel for data analytics. Most of the time, the data collection stage might result in glitches or incomplete data rows. These incomplete rows tend to result in inaccuracy in the final report. Eliminating the blank rows within a few steps could prove highly beneficial.

Learn Excel Basics for Free

Introduction to MS ExcelSTART LEARNING
Learn Excel Basics for Free

Wish to explore more about Business Analytics? Consider visiting the Business Analytics certification course from Simplilearn. It is Ranked among the topmost business analytics certifications in the Industry. Simplilearn's training program helps you master statistics and data analytics fundamentals. 

Should you have any queries about this "How to highlight duplicates in Excel" tutorial? Please feel free to write to us in the comments below. Our expert team will resolve them and will be happy to answer them at the earliest.

About the Author

Ravikiran A SRavikiran A S

Ravikiran A S works with Simplilearn as a Research Analyst. He an enthusiastic geek always in the hunt to learn the latest technologies. He is proficient with Java Programming Language, Big Data, and powerful Big Data Frameworks like Apache Hadoop and Apache Spark.

View More
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.