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 ...

If your spreadsheet has a lot of unwanted duplicate values, you're not stuck with them. You can remove them. We'll show you how to remove duplicates in Excel.

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.

You can remove duplicates in Excel in a few steps. Duplicates can create problems when you're dealing with data.