How to Identify Duplicate Items in Excel. Microsoft Excel helps you find duplicate values and identifies these cells with a color marker on your worksheet. This formatting lets you avoid the ...

Click the "Data" tab in the Microsoft Excel 2007 ribbon and locate the Data Tools group. Click on the "Remove Duplicates" item to bring up the Remove Duplicates dialog box.