How to Delete
Duplicates in Google
Sheets
Highlight the data range that may contain duplicates.
Click Data in the top menu and select Data cleanup > Remove duplicates.
If your range has headers, check the Data has header row box.
Click Remove duplicates, and Google Sheets will scan for identical rows.
A pop-up will show how many duplicates were found and removed.
Click OK to finalize, and your data will now be free of duplicates.
