As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

Duplicate Discovery: A Guide on How to Highlight Duplicates in Excel

Identifying and highlighting duplicate values in Excel is crucial for maintaining data accuracy. This guide will walk you through the steps to easily highlight duplicate values, helping you identify and manage duplicate entries within your spreadsheet.

Step 1: Open Your Excel Spreadsheet

1.1 Launch Microsoft Excel and open the spreadsheet where you want to highlight duplicates.

Step 2: Select the Range of Cells

2.1 Click and drag to select the range of cells where you want to identify duplicates.

Step 3: Go to the "Home" Tab

3.1 Navigate to the "Home" tab in the Excel ribbon.

Step 4: Use Conditional Formatting

4.1 Click on "Conditional Formatting" in the Excel ribbon.

Step 5: Choose "Highlight Cells Rules"

5.1 In the dropdown menu, choose "Highlight Cells Rules."

Step 6: Select "Duplicate Values"

6.1 Click on "Duplicate Values" in the submenu.

Step 7: Configure Formatting Options

7.1 In the "Duplicate Values" dialog box, you can choose the formatting options for highlighting duplicates. Select a format that makes duplicates stand out.

Step 8: Click "OK"

8.1 Click "OK" to apply the conditional formatting to highlight duplicate values.

Step 9: Review Highlighted Duplicates

9.1 The duplicate values in the selected range will be highlighted according to the chosen formatting.

Additional Tips:

  • Customize Formatting:
  • Experiment with different formatting options to make duplicate values easily noticeable. You can choose colors, bold text, or other formatting styles.
  • Use the "Remove Duplicates" Feature:
  • After highlighting duplicates, you may want to remove them. Go to the "Data" tab, click "Remove Duplicates," and choose the columns where you want to remove duplicate values.
  • Extend the Range:
  • If your dataset expands, adjust the range to include new data before reapplying the duplicate highlighting.


Highlighting duplicate values in Excel is a valuable step in maintaining data quality and avoiding errors. By following these steps, you can quickly identify and emphasize duplicate entries within your spreadsheet. Whether you're managing lists, databases, or any other data, highlighting duplicates contributes to a more accurate and reliable Excel dataset.