contador web Skip to content

How to Remove Duplicates in Excel | Productivity

Excel allows you to quickly identify and remove duplicate cells. The user can use the conditional formatting feature to mark repeated information and delete it manually. If necessary, you can also use a specific tool to remove duplicate items automatically in a few clicks. The function is useful for large spreadsheets or with many equal entries.

Excel formulas: the 68 most important functions of the program

In the following tutorial, see how to flag and delete duplicate information in Excel spreadsheets. The procedure was performed on the latest version of Office 2016, but the tips also apply to users of previous editions of the program.

Learn how to erase duplicate data in Excel simply Photo: Divulgao / MicrosoftLearn how to erase duplicate data in Excel simply Photo: Divulgao / Microsoft

Learn how to erase duplicate data in Excel simply Photo: Divulgao / Microsoft

Want to buy a cell phone, TV and other discounted products? Meet the Compare dnetc

Step 1. Open the Excel spreadsheet you want to check for duplicate items and select the desired data range;

Select table with data Photo: Reproduction / Helito BeggioraSelect table with data Photo: Reproduction / Helito Beggiora

Select table with data Photo: Reproduction / Helito Beggiora

Step 2. Now, go to "Conditional Formatting", open "Realize Cell Rules" and click "Duplicate Values ​​…";

Enable conditional cell formatting Photo: Reproduction / Helito BeggioraEnable conditional cell formatting Photo: Reproduction / Helito Beggiora

Enable conditional cell formatting Photo: Reproduction / Helito Beggiora

Step 3. If desired, change the highlight color to the duplicate values ​​and press "OK";

Choose the highlight color of duplicate cells Photo: Reproduction / Helito BeggioraChoose the highlight color of duplicate cells Photo: Reproduction / Helito Beggiora

Choose the highlight color of duplicate cells Photo: Reproduction / Helito Beggiora

Step 4. Still with the selected range, open the "Data" tab and click on the "Remove Duplicates" button, as indicated in the image;

Open duplicate removal feature Photo: Reproduction / Helito BeggioraOpen duplicate removal feature Photo: Reproduction / Helito Beggiora

Open duplicate removal feature Photo: Reproduction / Helito Beggiora

Step 5. Finally, select the columns in which you want to remove duplicate data and press "OK".

Choose the columns in which duplicate data will be removed. Photo: Reproduction / Helito BeggioraChoose the columns in which duplicate data will be removed. Photo: Reproduction / Helito Beggiora

Choose the columns in which duplicate data will be removed. Photo: Reproduction / Helito Beggiora

Ready! Take advantage of tips to quickly remove duplicate information in Excel spreadsheets.

How to delete all blank lines in Excel at once

How to delete all blank lines in Excel at once