How to Remove Duplicates in Google Sheets

Опубликовано: 28 Август 2026
на канале: Sheet Steps

Remove duplicates in Google Sheets: select the range, Data → Data cleanup → Remove duplicates. Sheets keeps the first copy.

Steps
1. Select the table including the header.
2. Data → Data cleanup → Remove duplicates.
3. Tick Data has header row.
4. Tick the columns to compare.
5. Click Remove duplicates. Read the popup. Click OK.

0:00 Remove duplicates
0:18 Select the table
0:32 Data cleanup
0:50 Header and columns
1:10 First copy stays

Watch next
How to Highlight Duplicate Values in Google Sheets
How to Insert a Checkbox in Google Sheets
How to Split Text to Columns in Google Sheets
How to Number Rows Automatically in Google Sheets

#GoogleSheets #Spreadsheet #HowTo