How to Delete Duplicate Rows in Excel

1. Select the entire spreadsheet by dragging an outline around it with the mouse. Click the 'Data' tab, then click the 'Advanced' button in the 'Sort Filter' box.If you are using Excel 2002 or 2003, click 'Data,' 'Filter,' 'Advanced Filter.'
2. Click the radio button labeled 'Filter the List, in Place' and check the box labeled 'Unique Records Only.' Click 'OK.' All of the duplicate rows will be hidden.
3. Select the entire spreadsheet, and then press the 'Ctrl' and 'C' keys on the keyboard to copy the selection.
4. Press the 'Ctrl' and 'N' keys on the keyboard simultaneously to create a new workbook.
5. Click in the top-left cell (A1) of the new workbook, and press the 'Ctrl' and 'V' keys on the keyboard to paste the spreadsheet into it. All duplicate rows will be gone from the spreadsheet.