When you are dealing with a large volume of data in a spreadsheet, you are bound to have duplicate entries. After all, no human is immune to making errors. But no worries, Google Sheets have a solution for it.
Having to remove duplicates one by one could be an extremely time-consuming task. But luckily, Google Sheets gives you the option to remove duplicates in just a few clicks.If you take a good look at the Sheets, you won’t see a direct button to perform the step. So then how to do it? You are lucky to have found this page. In this post, we are going to discuss the steps you need to follow to remove the duplicate entry in Sheets. Even if you are using Sheets for the first time, you should be able to follow the steps. So without wasting time, let’s get into the details.
Steps to remove duplicates in Google Sheets:
- Open Google Sheets:
- Now, select the column you want to remove duplicates from:
- Next, navigate to Data > Remove duplicates:
- You will now see a pop-up. Tick the box next to Data has header now > click Remove duplicates > click Done.
- Duplicates from the selected data will be removed:
Checkout our post on, How to highlight duplicates in Google Sheets, if you just want to highlight the duplicates.