How to delete duplicate rows in Excel and Google Sheets

Download PC Repair Tool to rapidly find & fix Windows errors automatically

Microsoft Excel is probably the most used spreadsheet software and among the alternatives bachelor is Google Sheets. Whether yous need to create a 5-column spreadsheet or a 50 column one, you lot can brand employ of Excel also as Google Sheets. Now, if you have a spreadsheet and information technology contains hundreds of aforementioned values in different rows, you can delete the duplicate rows in Excel and Google Sheets using this uncomplicated trick. We frequently receive spreadsheets which incorporate multiple duplicate rows. It happens when you merge two or more Excel sheets. Instead of finding out these indistinguishable rows manually ane-by-one, you tin can only delete them all at once.

Delete duplicate rows in Excel

Removing all duplicate rows is non that difficult when using Microsoft Excel since it comes with an inbuilt functionality. To go started, yous need to create the Excel spreadsheet. After that, go to Data tab and click on Remove Duplicates button.

Now, yous will be asked to select the column/due south where the duplicate rows are located.

You can select one row at a time if y'all are non sure. Otherwise, choose all the rows if you lot know what you lot are doing.

Delete indistinguishable rows in Google Sheets

As Google Sheets doesn't come with any inbuilt functionality, you need to take the help of a Chrome extension called Remove Duplicates. To install this Chrome extension for Google Sheets, you need to open your Google Drive business relationship, and then over to this folio and install it. Then, open up the desired spreadsheet > click on Add-ons > select Remove Duplicates > Find duplicates or uniques.

Then you need to select the range of the table. In other words, you tin can choose the columns and rows range. In step two (out of 4), select Duplicates (Find duplicates, exclude the get-go instances) and go forward. Subsequently that, select the cavalcade title and hit Next.

In the next footstep, y'all demand to select Delete rows within selection. After hit the End button, all the duplicate rows volition be removed instantly.

When using this addon, you lot need to know one thing.

Suppose, you lot take a price chart related spreadsheet which has only two columns, i.eastward., Goods Name and Price.

Goods Name	Price
Production name ane	$105
Production name 2	$75
Product proper noun 1	$95
Product name 3	$45

If you have the same goods proper name, multiple times, in Column A and dissimilar prices for the same appurtenances in Column B, and y'all delete duplicate rows from Cavalcade A, it will be a mess. But, if you know what you are doing, this tutorial should work fine.

Sudip loves to engage with the latest technology & gadgets. Apart from writing about all things technology, he is a Photoshop junkie and a football game enthusiast.