How to Delete Filtered Items in Excel 2007

1. Open Excel 2007 and then open the workbook containing the data you want to filter.
2. Select the range of cells you want to filter or click inside of a cell that is within the range of cells you want to filter.
3. Go to the 'Data' tab and click 'Advanced' in the 'Sort and Filter' group.
4. Select 'Filter the List, in Place' if you want to filter the list and delete duplicate items within the current worksheet. Choose 'Copy to Another Location' if you want Excel to delete the duplicate items and copy the remaining filtered items to another area on the worksheet.
5. Select the 'Unique Records Only' check box and click 'OK.' Excel will filter the list and delete any duplicate records it finds.