How to remove duplicates in Excel

To remove duplicates in Excel, you can follow these steps:

1. Select the range of cells from which you want to remove duplicates.
2. Click on the “Data” tab in the Excel ribbon.
3. Click on the “Remove Duplicates” button in the “Data Tools” group.
4. In the “Remove Duplicates” dialog box that appears, select the columns that you want to check for duplicates. You can either select all columns or specific columns.
5. Click on the “OK” button to remove the duplicates. Excel will display a message indicating how many duplicate values were removed and how many unique values remain.
6. Click on the “OK” button to close the message box.

Note: Excel removes only the duplicate values and keeps the unique values in the selected columns. If you want to remove duplicates from the entire worksheet, you need to select all the columns before clicking the “Remove Duplicates” button.