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.
2. In the Toolbar Select: Data > Data Cleanup > Remove Duplicates
Go to the Toolbar and click data. From the dropdown menu go to ‘Data Cleanup’ and in this sub menu click ‘Remove Duplicates’
3. In the Remove Duplicates Menu Click on Data Header Rows to Remove
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.
4. Click on on the Pop Up
The Duplicate rows have been removed and a notification will display how many have been deleted and how many remain.
Step 5: Duplicate Data Removed
The duplicate data rows have been removed and the sheet now only has unique fields remaining.
In this article we demonstrated the application of how to remove duplicate rows in Google Sheets.