How does Excel delete duplicate data?

Source: Internet
Author: User

How does Excel delete duplicate data? When you make Excel tables, you often need to find duplicates and remove them. It's a lot of trouble to find it by hand. We can use conditional formatting to display duplicates in different colors, or we can use some formulas to find out duplicates, and then remove duplicates, so how does Excel delete duplicate data? The following small series for everyone to introduce, to see!


First, we double-click to open the Excel spreadsheet that needs to be edited as shown

After you open the spreadsheet that you want to edit, we click on the "Data" option on the menu bar as shown

After opening the data options, we click to select the content area that we need to edit as shown

After selecting the content area that you want to edit, we click the "Remove Duplicates" icon in the toolbar as shown

In the open Delete Duplicates Settings window, we check the columns that need to delete duplicate values according to our situation, and then click OK as shown

After completing the above steps, if the checked column does have duplicate content, then will be prompted to have deleted the number of duplicate values, we click "OK" to complete the Excel spreadsheet repeat the deletion step of the figure

The above is how Excel deletes the duplicate data method introduction, the operation is very simple, hoped can have the help to everybody!

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.