» Remove Duplicate Rows in Excel 2007
To remove duplicate rows from a Table:
1. Select a cell in the Table range.
2. Select Design tab (in Table Tools Ribbon) -> Remove Duplicate (in Tools Group).
3. Use Select All option or select only the columns you want to compare duplicates.