Spreadsheets

  1. Home
  2. Computing & Technology
  3. Spreadsheets

Remove Duplicate Data Records in Excel 2007

By Ted French, About.com

Remove Duplicate Data in Excel 2007

Remove Duplicate Data in Excel 2007

© Ted French

Note: For help with this article see the image to the right.

Related article: Find Duplicates in Excel with Conditional Formatting.

To remove duplicate data records from a database in Excel 2007 :

  1. Click on any cell in the database.

  2. Click the Data tab on the Ribbon.

  3. Click on the Remove Duplicates option.

  4. Doing so will select all the data in the database and open the Remove Duplicates dialog box.

  5. When the dialog box opens, all of the column headings are selected by default.

To remove only those records from the database that match another record exactly:

  1. Leave all column headings selected and Click OK.

To remove records from the database that have duplicate data in only one or more columns:

  1. Remove the check marks from those columns you do not want to compare.

  2. Click OK

Note: If you remove the wrong data, click the Undo button on the Quick Access toolbar or press CTRL + Z on the keyboard to get your data back.

Related Articles

More Spreadsheets Quick Tips

Explore Spreadsheets

About.com Special Features

Spreadsheets

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Data Management in Excel
  5. Excel Data - Excel Duplicate Data - Remove Duplicate Data in Excel 2007

©2009 About.com, a part of The New York Times Company.

All rights reserved.