Tips for removing duplicate data in Excel 2007

First step: Find duplicate data

Open Excel First, select the data area you want to defragment, then select Conditional Formatting on the Start tab, select Highlight cell rule/duplicate value in the Drop-down menu, and select an appropriate style in the Duplicate Values dialog box that pops up to highlight duplicate values, without special requirements. Keep the default, and then click OK, and the duplicate values are highlighted.

Figure 1 Excel 2007 shows duplicate values

Step two: Remove duplicate values

After you find the duplicate values, click to switch to the Data tab, select Delete duplicates, and in the Remove Duplicates dialog box, tick the column that you want to remove duplicate values from, and then click OK, and the duplicate data is cleaned up.