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.	Exam 77-882: Microsoft Excel 2010 Core 3. Formatting Cells and Worksheets 3.1. Apply and modify cell formats: Remove duplicates in a Table Table Tools-> Design ->Tools-> Remove Duplicates