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 / 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 Beggiora
Step 2. Now, go to "Conditional Formatting", open "Realize Cell Rules" and click "Duplicate Values …";
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 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 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 Beggiora
Ready! Take advantage of tips to quickly remove duplicate information in Excel spreadsheets.
How to delete all blank lines in Excel at once
