In this article we will show you exactly how to remove duplicate rows in Google Sheets. Just follow the simple steps below:
For the purposes of this demonstration a sample sheet was created. Click here to access this sheet and follow along with the tutorial.
To select all the data in your sheet, left click and hold the top most left cell and drag the mouse to cover your entire field of data.
An alternate method of selection would be to click anywhere in the data field, press and hold CTRL + A for PC and ⌘-key + A for MAC for the whole data field to be selected.
Go to the Toolbar and click data. From the dropdown menu go to ‘Data Cleanup’ and in this sub menu click ‘Remove Duplicates’
Before the duplicates are removed, a box will appear that will ask if your data set has a header. It is advisable to click this as leaving it unticked would lead to any duplicate headings being removed as well as data.
When checked the name of the data headers will appear in the analytics. Click the ‘Remove Duplicates’ button to activate the function.
The Duplicate rows have been removed and a notification will display how many have been deleted and how many remain.
The duplicate data rows have been removed and the sheet now only has unique fields remaining.
We hope this article has helped you on how to remove duplicate rows in Google Sheets. You might also like our article on how to use the shortcut to delete rows in Google Sheets and our tutorial on how to group rows in Google Sheets.
On a side note, we also recommend reading our guide on how to set a reminder on Google Sheets to optimize your workflow.
