How to Remove Duplicates in Google Sheets

In Google Sheets, you can highlight the duplicates using the conditional formatting. You can also quickly remove the duplicates with the command.

Step 1: Click anywhere in the data range;

Step 2: Click the "Data" tab from the ribbon;

Step 3: Click "Remove duplicates" from the drop-down list;

Step 4: In the new dialog box, decide how you want to remove the duplicates, e.g., remove duplicate based on column A;

Step 5: A quick summary message will display;

Step 6: The data range after removing duplicates will display.

Leave a Reply