Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web
  1. Select the cell range where you want to remove the duplicates.

  2. On the Data tab under Data Tools, select  Excel Remove Duplicates icon Remove Duplicates.

  3. Include all the columns with duplicates and select OK.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.