How to Check for Duplicates in Excel

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.
2. Click the Microsoft Office button, and click 'Open.' Navigate to the spreadsheet file to search for duplicates.
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.
4. Click 'Data' from the top navigation ribbon. Click 'Filter' and then click 'Advanced Filter.'
5. Click the 'Filter the List, in Place' option.
6. Check the check box in front of the 'Unique Records Only' option, and then click 'OK.'
7. Click the 'Edit' option on the top navigation ribbon, and then click 'Office Clipboard.'
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.
9. Click 'Filter' and then click 'Show All' from the Data pane in the top navigation ribbon. The original data are displayed, including duplicates.
10. Press the 'Delete' key to delete the original list.
11. Click the filtered list in the clipboard pane. The filter list replaces the original list in the Excel file. Duplicate records are removed.
12. Click the 'Microsoft Office' button, and then click 'Save' to save your new filtered list.