To remove duplicated data from your Excel spreadsheet

1. Highlight the range of cells with duplicated data. Select Data, then Remove Duplicates, then select OK.
   
2. The cells with duplicated data will be removed