Duplicate information is expensive, it skews studies and results in wasted advertising sources. Right here’s the right way to take away duplicates in Excel spreadsheets:

Let’s run via it with an instance!

Notice: If you wish to see duplicate information earlier than eradicating them, scroll right down to discover ways to discover and spotlight duplicates in Excel. Additionally, make a duplicate of your worksheet so you continue to have your authentic information for those who delete one thing vital.

Find out how to Take away Duplicates in Excel

1. Choose the cells you want to take away duplicates from.

Click on on a cell and maintain down the left mouse button. Then drag the cursor over the opposite cells you wish to choose.

Or, use the Shift + arrow keyboard shortcut to pick out the vary you need.

2. Click on on the “Information” tab on the prime.

3. Click on “Take away Duplicates” to disclose a pop-up.

It is best to see a pop-up that appears like this:

4. Uncheck any columns with information you wish to hold. 

5. Click on OK to delete the duplicates.

Excel will hold the primary prevalence of the worth by default.

Find out how to Spotlight Duplicates in Excel

Generally, you wish to see the duplicate information earlier than you delete it. Right here’s the right way to discover duplicate information in Excel:

1. Choose the cells you want to examine for duplicates.

Click on on a cell and maintain down the left mouse button. Then drag the cursor over the opposite cells you wish to choose.

Or, use the Shift + arrow keyboard shortcut to pick out the vary you need.

2. Click on “Conditional Formatting” from the house tab to disclose a drop-down.

First, navigate to the house tab for those who’re on a distinct tab.

Click on on “Conditional Formatting” to disclose a dropdown.

3. Hover over “Spotlight Cell Guidelines”

4. Select “Duplicate Values” from the choices.

5. Choose the formatting possibility you need and click on OK.

You’ll discover all duplicates highlighted within the formatting model you select.

Now you know the way to seek out and take away duplicates in Excel! 

Need extra Excel automation hacks? Excel templates are a superb place to begin. They arrive pre-formatted with formulation that assist you to automate projections and extra.

Editor’s notice: This publish was initially printed in [Month Year] and has been up to date for comprehensiveness.