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...