![how to excel find duplicates how to excel find duplicates](https://cdn.ablebits.com/_img-blog/identify-duplicates/find-duplicate-rows-excel.png)
This will now highlight the Unique Values in the spreadsheet. Find and Highlight Duplicates in Excel 1) Select the range of data in which you want to find the duplicates.
![how to excel find duplicates how to excel find duplicates](https://www.absentdata.com/wp-content/uploads/2019/05/Duplicate-Vlaues-Excel-1.png)
Follow the same procedure as above then when you are in the Duplicate Values dialogue box, click on Unique in the drop down menu. You can also use the conditional formatting button to highlight Unique Values in a spreadsheet.
![how to excel find duplicates how to excel find duplicates](https://appauthority.com/wp-content/uploads/2021/07/excel-duplicates-2-1200x477-1-1024x407.jpeg)
You can click individual columns or rows, or you can hold down the Ctrl button and then select them. Select the columns and rows that you need to check for duplicates. There are various ways of finding the duplicate values in content, but the simplest way to do this can be done using the Conditional Formatting button on the Home tab. Sometimes when you are using Excel spreadsheets, you may find that you need to check cells for duplicate values, for example if you have merged data from two worksheets into one and you have to check if data has been duplicated.