How to delete duplicate rows from a list in Excel?

Follow the steps given below:

1. Select all the rows, including the column headers, in the list you want to filter.
2. On the Data menu, point to Filter, and then click Advanced Filter.
3. In the Advanced Filter dialog box, click Filter the list, in place.
4. Select the Unique records only check box, and then click OK.
5. On the Edit menu, click Office Clipboard.
6. Make sure the filtered list is still selected, and then click Copy Copy button.
7. On the Data menu, point to Filter, and then click Show All.
8. Press the DELETE key.
9. In the Clipboard, click on the filtered list item.

Tags: Microsoft, Office, Troubleshooting, Software

Related