If your spreadsheet has a lot of unwanted duplicate values, you're not stuck with them. You can remove them. We'll show you how to remove duplicates in Excel.

Install the Remove Duplicates add-on from the Google Workspace Marketplace. In your sheet, click Extensions, then Remove Duplicates, and choose: Find Duplicates or Uniques.

Navigate to the Add-ins tab and click on the Go button present beside the Manage Excel Add-ins option. In the Add-ins dialog window, enable the relevant checkboxes to turn on the required add-in.

How to delete duplicates in Excel? To remove duplicates in Excel sheets follow these simple steps: Select the rows from which you’d like to remove duplicate data, go to Data tab and select Remove ...

Once you add them to your Ribbon, Excel's Developer tools enable you to edit or remove that pesky check box.