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 Fotolia.com)

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:
Easy

Other People Are Reading

Instructions

  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

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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