Duplicate data can be a headache in any spreadsheet, but it’s especially troublesome in Excel. Here’s how to delete duplicates from your spreadsheet:

  1. Open your Excel spreadsheet and select the data you want to delete.
  2. Click on the “Data” tab and select “Sort.”
  3. On the “Sort” dialog box, click on the “Duplicate rows” button and select “Delete.”
  4. Click on OK to finish deleting duplicates from your spreadsheet. ..