Excel can delete duplicates by setting duplicate values and setting advanced filters. Take setting duplicate values as an example: 1. First, open the Excel table that needs to be deleted, and select the content that needs to be deleted. 2. Then click "Data" and click "Delete Duplicates". 3. Finally, click OK, click OK.