back to gallery
Launch Excel and open the workbook containing the data with duplicates you want to remove.
Click and drag to highlight the range of cells that contains the duplicates. Ensure you include all relevant columns.
Navigate to the top menu and click on the **Data** tab to access data management options.
In the Data Tools group, find and click the **Remove Duplicates** button. A dialog box will appear.
In the dialog box, check the columns you want to use for identifying duplicates. Click **OK** to proceed.
After the process completes, Excel will display a message indicating how many duplicates were removed. Click **OK** to finish.