Removing duplicates is a handy feature that can help you clean up your data and allows accurate reporting in Google spreadsheets. This post gives you a quick guide to remove duplicated rows in Google Sheets easily without any formula! Just click and see the magic!
Let's say you have a list of students name and their age, and birthdate that you collected via Google Form. For some reasons, some of the students submitted the form twice.
To keep the list accurate, we have to remove the repeating records. If you want to delete the repeating records quickly without messing with google sheets formulas, this post is for you!
Step 1: Select the Data Range
Select the range of data that includes the duplicated rows.
Step 2: Settings
Click on the “Data” menu at the top of the screen. Select "Data clean-up" > select "Remove duplicates".
Step 3: Select Columns to Check
Select the columns you want to check for duplicates. Uncheck the columns to exclude from the duplicate check.
Select "Remove duplicates" and the duplicated rows would be removed immediately.
Bonus Tips: Highlighting Repeating Rows In Real-Time
Did you know that you can use conditional formatting to find and highlight duplicates in your spreadsheet? It's a great way to easily spot any duplicate entries and take action on them.
Check out this article to learn how to apply conditional formatting, with a simple formula.
