How to Remove Duplicate Rows From an Excel Spreadsheet

1.
Click on the 'File' menu and then the 'Open' option to open the spreadsheet with the duplicate rows. The example highlights the duplicate rows for easier viewing.
2. Select the entire spreadsheet by clicking on the top left cell of the column header and then scrolling to the last row. Press the 'Shift' key and click on the lowest right cell with information. The rows are highlighted.
3.
Click on the 'Data' menu, 'Filter' and then 'Advanced Filter.' The Advanced Filter dialog box appears.
4. Choose 'Filter the List, In Place' and 'Unique Records Only.' Then click the 'OK' button. Excel hides the duplicated records.
5. With the filtered records still selected, press the 'Ctrl' and 'C' keys to copy the rows. The list is highlighted with bounding outlines.
6.
Click on the 'View' menu, 'Toolbars' and then 'Clipboard.' The Clipboard window appears with your copied data in the first icon.
7. Click on the 'Data' menu, 'Filter' and then 'Show All' to display the original list.
8. With the original list still selected, press the 'Delete' key. The list is deleted.
9.
Click the first icon in the 'Clipboard' window. The list appears with no duplicates. The example highlights the filtered rows for easy viewing.
10. Click the 'Save' button to save the spreadsheet.