How to Check for Duplicates in Excel

By Tammy Clevenger

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.

Step 1

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.

Step 2

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

Step 3

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.

Step 4

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

Step 5

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

Step 6

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

Step 7

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

Step 8

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.

Step 9

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

Step 10

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

Step 11

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

Step 12

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