Exam 77-420 Microsoft Excel 2013 3. Create Tables 3.3 Filter and Sort a Table: Remove Duplicates Table: Remove Duplicates When people enter data into a table or list, it is easy to make a mistake and type a name twice. Duplicates happen. In this example, we will copy and paste a Row, then go through the steps to find the duplicate. 1. Try This: Create the Duplicate Select Row 69 Go to Home->Clipboard->Copy. Select Cell A70. (In our example, we added a new, blank Row 70 a few pages back.) Go to Home->Clipboard->Paste. What Do you See? The pasted Cells are a duplicate of the Row that you copied.   Keep going... Home->Clipboard->Copy