How to check for duplicate records in excel

Written by contributing writer
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to check for duplicate records in excel
Eliminate duplicate records in Excel. (black database image by .shock from

Creating a spreadsheet in Excel 2007 means multiple cells, rows and columns. Data values and data sets can often be duplicated in the columns and rows. Locating duplicate data records in a spreadsheet is a priority when accurate results are expected. Excel 2007 provides a solution for this by using a colour code to check your spreadsheet for duplicate records.

Skill level:

Other People Are Reading


  1. 1

    Click the "Home" tab.

  2. 2

    Click "Conditional Formatting" in the "Styles" box in the Office ribbon.

  3. 3

    Select "Highlight Cell Rules" and then "Duplicate Values." The "Duplicate Values" box will open.

  4. 4

    Select "Duplicate" from the drop-down box and choose the colour for the highlighted duplicates. Click "OK." Excel will show all duplicate values in the colour that was chosen.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.