How to Remove Duplicates in Excel (5 Steps With Pictures)

Duplicate knowledge is dear, it skews experiences and results in wasted advertising and marketing assets. Right here’s how you can take away duplicates in Excel spreadsheets:

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

Observe: If you wish to see duplicate knowledge earlier than eradicating them, scroll right down to discover ways to discover and spotlight duplicates in Excel. Additionally, make a replica of your worksheet so you continue to have your unique knowledge in case you delete one thing vital.

The best way 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 is 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.

The best way to Spotlight Duplicates in Excel

Generally, you need to see the duplicate knowledge earlier than you delete it. Right here’s how you can 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 in case you’re on a distinct 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. Choose the formatting possibility 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 know the way to seek out and take away duplicates in Excel! 

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

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

excel marketing templates

Latest news
Related news

LEAVE A REPLY

Please enter your comment!
Please enter your name here