Delete duplicate data/display duplicate data in Excel table

Method 1: Highlight duplicate data

You can highlight repetitive data so you can find them and avoid repetitive entries. The procedure is as follows:

2. First, select the scope of the duplicate data you want to find. For example, if you are looking for duplicates in the employee number, select the "Employee Number" column.
4. Then on the Start tab-> conditional formatting -> highlight the cell rules -> Duplicate values .
   Put this picture away. expand this picture
6. On the Duplicate Value dialog box, select the format you want to highlight the duplicates, and then determine .
   Put this picture away. expand this picture
8. Get! Repeat the content at a glance, so you can take appropriate measures slightly.
   Put this picture away. expand this picture

Method 2: Easily remove duplicate data

You can use Excel to remove duplicate data and delete duplicates. The procedure is as follows:

2. Select the range for which you want to delete duplicate data. For example, select the entire table.
4. Then-> deletes duplicates on the Data tab.
   Put this picture away. expand this picture
6. dialog box. In which columns do you need to find duplicates, tick the list, .
   > close this picture
8. expand this picture

   or