Exam 77-420 Microsoft Excel 2013
3. Create Tables
3.3 Filter and Sort a Table: Remove Duplicates

Table: Remove Duplicates

2. Try This: Remove Duplicates

Click anywhere on the Table. The Table Tools should be available.

Go to Table Tools-> Design ->Tools.

Click on Remove Duplicates.

What Do You See? Each of the Columns in our table is selected. The Column Names come from the Header Row.

When you click on OK, the duplicates will be found and removed.

 

So, that's good, too.

graphic1
graphic3
graphic2
Table Tools-> Design ->Tools-> Remove Duplicates