Removing duplicates in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the 'Remove Duplicates' feature do in Excel?

It deletes repeated rows or values in a selected range, leaving only unique entries.

beginner

How do you access the 'Remove Duplicates' tool in Excel?

Go to the Data tab on the ribbon, then click the 'Remove Duplicates' button in the Data Tools group.

beginner

Can you choose which columns to check for duplicates when using 'Remove Duplicates'?

Yes, Excel lets you select one or more columns to check for duplicate values before removing them.

intermediate

What happens if you remove duplicates from a list with multiple columns selected?

Excel removes rows where all selected columns have the same values, keeping only the first occurrence.

beginner

Is it possible to undo removing duplicates after applying it?

Yes, you can press Ctrl + Z immediately after to undo the removal and restore the original data.

Where is the 'Remove Duplicates' option located in Excel?

A Data tab

B Home tab

C Insert tab

D Review tab

The 'Remove Duplicates' feature is found under the Data tab in Excel.

What does Excel consider a duplicate when removing duplicates?

A Any cell with the same value anywhere in the sheet

B Only the first column values

C Rows with identical values in selected columns

D Only empty cells

Excel removes rows where the values in the selected columns are exactly the same.

Can you select multiple columns to check for duplicates in Excel's Remove Duplicates?

A Only adjacent columns

B Yes

C Only one column at a time

D No

Excel allows selecting multiple columns to define what counts as a duplicate row.

What should you do before removing duplicates to avoid losing important data?

A Nothing, it's safe always

B Close Excel

C Delete all data first

D Make a backup copy of your data

It's best to save a copy before removing duplicates to prevent accidental data loss.

How can you reverse the removal of duplicates immediately after applying it?

A Press Ctrl + Z

B Close Excel without saving

C Use the Filter feature

D Restart the computer

Pressing Ctrl + Z undoes the last action, restoring removed duplicates.

Explain how to remove duplicates from a list in Excel step-by-step.

Think about the buttons and options you click in order.

Why is it important to select specific columns when removing duplicates?

Consider how Excel decides which rows to delete.