Find duplicate data in Excel 2007

In the weeks, excel in the collection of a large number of information, often there will be some duplication of data, can not find these duplicate data, can not be deleted and other operations.

With Excel 2007, you can easily find these duplicate data.

For example, the following table of data, to find a part of the duplicate data, the operation is as follows:

Select the range of data you want to defragment, click Conditional Formatting on the Start tab, and select duplicate values in the highlight cells rule, as shown in the following figure

This allows you to quickly highlight duplicate values. The following figure: