You are viewing the article How to Delete Duplicate Data in Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 3,167 times.
This wikiHow teaches you how to remove duplicate data from a Microsoft Excel spreadsheet.
Steps
Delete Duplicate Data
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/5b/Remove-Duplicates-in-Excel-Step-1-Version-4.jpg/v4-728px-Remove-Duplicates- in-Excel-Step-1-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/5b/Remove-Duplicates-in-Excel-Step-1- Version-4.jpg/v4-728px-Remove-Duplicates-in-Excel-Step-1-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Double-click the Excel document. The workbook will open in Excel.
- You can also open existing documents in the “Recent” section of the Open tab.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8d/Remove-Duplicates-in-Excel-Step-2-Version-4.jpg/v4-728px-Remove-Duplicates- in-Excel-Step-2-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/8d/Remove-Duplicates-in-Excel-Step-2- Version-4.jpg/v4-728px-Remove-Duplicates-in-Excel-Step-2-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select the data group. Click the top item of the data, hold down the ⇧ Shift key, and then click the last item.
- If you want to select multiple columns, click the upper-left item and then click the lower-right item while you hold down the ⇧ Shift key.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/06/Remove-Duplicates-in-Excel-Step-3-Version-4.jpg/v4-728px-Remove-Duplicates- in-Excel-Step-3-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/06/Remove-Duplicates-in-Excel-Step-3- Version-4.jpg/v4-728px-Remove-Duplicates-in-Excel-Step-3-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the Data tab on the left side of the green ribbon at the top of the Excel window.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f5/Remove-Duplicates-in-Excel-Step-4-Version-4.jpg/v4-728px-Remove-Duplicates- in-Excel-Step-4-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f5/Remove-Duplicates-in-Excel-Step-4- Version-4.jpg/v4-728px-Remove-Duplicates-in-Excel-Step-4-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Remove Duplicates . The option is in the “Data Tops” section of the Data toolbar near the top of the Excel window. A window will pop up with select/deselect columns.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/1a/Remove-Duplicates-in-Excel-Step-5-Version-4.jpg/v4-728px-Remove-Duplicates- in-Excel-Step-5-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/1a/Remove-Duplicates-in-Excel-Step-5- Version-4.jpg/v4-728px-Remove-Duplicates-in-Excel-Step-5-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
You need to make sure that each column you want to edit is selected. You will see various column names (such as “Cpumn A”, “Cpumn B”) next to the check box; Click the check box to deselect the column you don’t need.
- By default, all columns next to the object you select will be listed and pre-tagged in this list.
- You can click Select All to select all columns in the list.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f5/Remove-Duplicates-in-Excel-Step-6-Version-4.jpg/v4-728px-Remove-Duplicates- in-Excel-Step-6-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f5/Remove-Duplicates-in-Excel-Step-6- Version-4.jpg/v4-728px-Remove-Duplicates-in-Excel-Step-6-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click OK . Any duplicate data will be removed from the Excel spreadsheet.
- If no duplicate data is reported when you know for sure there is, you should select each column at a time.
Mark duplicate data
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/02/Remove-Duplicates-in-Excel-Step-7-Version-4.jpg/v4-728px-Remove-Duplicates- in-Excel-Step-7-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/02/Remove-Duplicates-in-Excel-Step-7- Version-4.jpg/v4-728px-Remove-Duplicates-in-Excel-Step-7-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Double-click the Excel document. The worksheet will open in Excel so you can check which cells have the same value using the Conditional Formatting feature. This is the right way to go if you just need to find duplicate data and don’t want to delete these values by default.
- You can also open existing documents in the “Recent” section of the Open tab.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/85/Remove-Duplicates-in-Excel-Step-8-Version-3.jpg/v4-728px-Remove-Duplicates- in-Excel-Step-8-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/85/Remove-Duplicates-in-Excel-Step-8- Version-3.jpg/v4-728px-Remove-Duplicates-in-Excel-Step-8-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click in the upper left cell of the data group to select.
- Do not include a title (eg “Date”, “Time”, etc.) in the selection.
- If you only selected one row, click the leftmost heading of the row.
- If you only selected one column, click the heading at the top of the column.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2b/Remove-Duplicates-in-Excel-Step-9-Version-4.jpg/v4-728px-Remove-Duplicates- in-Excel-Step-9-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2b/Remove-Duplicates-in-Excel-Step-9- Version-4.jpg/v4-728px-Remove-Duplicates-in-Excel-Step-9-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Hold down the ⇧ Shift key and click in the lower right cell. This will select all data between the upper left and lower right corners of the data group.
- If you select only one row, click on the rightmost cell containing the data.
- If you only selected one column, click the item containing the data at the bottom.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b5/Remove-Duplicates-in-Excel-Step-10-Version-4.jpg/v4-728px-Remove-Duplicates- in-Excel-Step-10-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b5/Remove-Duplicates-in-Excel-Step-10- Version-4.jpg/v4-728px-Remove-Duplicates-in-Excel-Step-10-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Conditional Formatting . The option is in the “Styles” section of the Home tab. A drop-down menu will appear.
- You may need to click the Home tab at the top of the Excel window first to find this option.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d0/Remove-Duplicates-in-Excel-Step-11-Version-4.jpg/v4-728px-Remove-Duplicates- in-Excel-Step-11-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d0/Remove-Duplicates-in-Excel-Step-11- Version-4.jpg/v4-728px-Remove-Duplicates-in-Excel-Step-11-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select Highlight Cells Rules . A window will pop up.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/ce/Remove-Duplicates-in-Excel-Step-12-Version-4.jpg/v4-728px-Remove-Duplicates- in-Excel-Step-12-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/ce/Remove-Duplicates-in-Excel-Step-12- Version-4.jpg/v4-728px-Remove-Duplicates-in-Excel-Step-12-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Duplicate Values at the bottom of the pop-up menu. All duplicates in the range you selected will be highlighted.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 3,167 times.
This wikiHow teaches you how to remove duplicate data from a Microsoft Excel spreadsheet.
Thank you for reading this post How to Delete Duplicate Data in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: