How to remove duplicates in Microsoft Excel

Microsoft Excel is a really highly effective doc processing software particularly in the case of making reviews, calculations and storing a database for any specific challenge. Nonetheless, at instances, whereas creating an excel spreadsheet people usually face challenges and make errors on account of duplicate values in your information.

Fortunately, Microsoft Excel comes with a characteristic that permits customers to seek out duplicate values and take away them. Comply with our step-by-step information to seek out and take away duplicate values in Microsoft Excel spreadsheets.

Do note that deleting duplicates will completely take away these values.

How to find and remove duplicates in Excel

Choose the cells for which you want to search for duplicate values


Click on Home and head to Conditional Formatting choice


Right here, select Duplicate Values choice beneath Spotlight Cells Guidelines part


Now, choose the formatting you wish to apply for duplicate values and click on on Okay


As soon as the values are highlighted, choose the vary of cells that has duplicate values


Click on Knowledge and choose Take away Duplicates and test or uncheck the columns the place you wish to take away the duplicate values.


Click on Okay to use the modifications

Also Read |  Redmi Word eight Professional with 64MP Digicam, Mediatek G90T Processor Leaked [Update: Launch Date]