How to Check for Duplicates in Excel

Written by tammy clevenger | 13/05/2017
How to Check for Duplicates in Excel
Filter duplicates in Excel 2010. (Jupiterimages/ Images)

Microsoft Excel 2010 is the spreadsheet application provided with the Microsoft Office 2010 suite of productivity products. Excel 2010 introduces a few new features to the spreadsheet application. Excel 2010 makes checking for duplicate records an easy task with the new Unique Records Only feature. A duplicate row, or record, in Excel is a row that contains the exact data that are contained in another row. Once duplicate records are identified, the duplicated row is deleted, retaining only unique records in the spreadsheet.

Click the Windows "Start" button and select "All Programs." Click the "Microsoft Office 2010" folder to expand the contents of the folder. Click the "Microsoft Excel 2010" option to launch the Excel application.

Click the Microsoft Office button, and click "Open." Navigate to the spreadsheet file to search for duplicates.

Click the top leftmost cell to select the entire worksheet. To select a range of cells, click the top leftmost cell and drag the cursor to select the desired columns and rows.

Click "Data" from the top navigation ribbon. Click "Filter" and then click "Advanced Filter."

Click the "Filter the List, in Place" option.

Check the check box in front of the "Unique Records Only" option, and then click "OK."

Click the "Edit" option on the top navigation ribbon, and then click "Office Clipboard."

Click the "Copy" icon on the top navigation ribbon, or press the "Ctrl" + "C" keys to copy the Excel data to the clipboard in the left pane of the Excel interface.

Click "Filter" and then click "Show All" from the Data pane in the top navigation ribbon. The original data are displayed, including duplicates.

Press the "Delete" key to delete the original list.

Click the filtered list in the clipboard pane. The filter list replaces the original list in the Excel file. Duplicate records are removed.

Click the "Microsoft Office" button, and then click "Save" to save your new filtered list.

  • 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.