Thursday, August 11, 2022
HomeB2B MarketingEasy methods to Take away Duplicates in Excel (5 Steps With Photos)

Easy methods to Take away Duplicates in Excel (5 Steps With Photos)


Duplicate knowledge is expensive, it skews reviews and results in wasted advertising assets. Right here’s the way to take away duplicates in Excel spreadsheets:

Download 10 Excel Templates for Marketers [Free Kit]

Let’s run by means of it with an instance!

Notice: If you wish to see duplicate knowledge earlier than eradicating them, scroll all the way down to learn to discover and spotlight duplicates in Excel. Additionally, make a replica of your worksheet so you continue to have your unique knowledge should you delete one thing essential.

Easy methods 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 need to choose.

How to Remove Duplicates in Excel: to remove duplicates in excel, select all the cells you want

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

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

click on dataHow to Remove Duplicates in Excel: t, step 2 to remove duplicates in excel

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

How to Remove Duplicates in Excel: tstep 3 to remove duplicates in excel, click on "remove duplicates"It’s best to see a pop-up that appears like this:

How to Remove Duplicates in Excel: ta popup to remove duplicates in excel

4. Uncheck any columns with knowledge you need to maintain. 

How to Remove Duplicates in Excel: tuncheck colums with data you don't want to delete in excel

5. Click on OK to delete the duplicates.

How to Remove Duplicates in Excel: tclick ok to delete duplicates

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

Easy methods to Spotlight Duplicates in Excel

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

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

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

How to Highlight Duplicates in Excelto highlight duplicates in excel, select all the cells you want

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 should you’re on a special tab.

How to Highlight Duplicates in Excelclick conditional formatting to find duplicates in excel

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

click on Conditional Formatting to find duplicates in excel

3. Hover over “Spotlight Cell Guidelines”

How to Highlight Duplicates in Excelhover over highligh cell rules to find duplicates in excel

4. Select “Duplicate Values” from the choices.

choose duplicate values to highlight duplicate values

5. Decide the formatting choice you need and click on OK.

How to Highlight Duplicates in Excelchoose the formatting style you want to highlight your duplicate excel data with

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

Now you understand how to seek out and take away duplicates in Excel! 

Need extra Excel automation hacks? Excel templates are a very good place to start out. They arrive pre-formatted with formulation that show you how to automate projections and extra.

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

excel marketing templates

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -
Google search engine

Most Popular

Recent Comments