How to delete duplicate rows in excel and keep the first row

How to delete duplicate rows in excel and keep the first row: first select the cell and click the "Data" option in the toolbar above the table; then click "Delete Duplicate Values" in the "Data" tab Options icon; finally check columns A and B and click the OK button.

How to delete duplicate rows in excel and keep the first row:

1. First enter in the excel table Two columns of cell data need to be deleted to retain only one row.

#2. After selecting the cell, click the "Data" option in the toolbar above the table.

#3. Then click the option icon of “Delete Duplicates” in the “Data” tab.

#4. After selection, a dialog box for deleting duplicates will pop up. Check columns A and B, and click the OK button.

#5. You can delete the duplicate cells from the original cells, leaving only one piece of non-duplicated data.

Related learning recommendations: excel tutorial

The above is the detailed content of How to delete duplicate rows in excel and keep the first row. For more information, please follow other related articles on the PHP Chinese website!