hi Candan,

select the row / column , go to Home - conditional formatting - highlight Cell rules - Duplicate values this will highlight the duplicates

if you want to remove duplicate then ,

Go to Home - Data - Remove duplicate

Thanks,
A