Comma Training Page 42

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

Select Cell A70. (In our example, we added a new, blank Row 70 a few pages back.)

Go to Home->Paste.

What Do you See? The pasted Cells are a duplicate of the Row that you copied.

Keep going...

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