In the use of Excel to deal with big data, often need to repeat the data de-duplication process, novice friends may be a line of deletion. In fact, to find the right method is simple, we only need to retain the unique value, and remove other duplicate rows on it. Next, I will share with you Excel to remove duplicate data rows of graphic tutorials.

The following figure for today's example: because the content is less, so a glance at the duplicate data. Here we will use Excel to test, is it possible to remove the last three rows of duplicate data all at once?

1, the cursor will be positioned in the form, switch to the "Data" tab, in the "Data Tools" group click "Remove Duplicates" button.

2, the pop-up "Delete Duplicate Items" dialog box, click "OK" button, and then continue to click "OK" button in the dialog box jumped to.

Well, duplicate lines have been deleted, leaving only one line. Too simple for you? Actually it is that simple!