How to Filter Duplicates in Excel

1. Click 'Start' then 'All Programs.' Open Excel 2010 by clicking 'Microsoft Office Excel 2010.'
2. Click 'File' then 'Open.' Select the Excel spreadsheet that contains the duplicate data you wish to filter.
3. Click the 'Data' tab then click the 'Remove Duplicate' button. A dialog box opens which lets you select the columns and rows that you want Excel to scan for duplicate data.
4. Click 'Select All' then click 'OK.'
5. Click 'OK' once more to confirm the success of the operation. The spreadsheet is now filtered of duplicate data.