PURPOSE Removing duplicates helps clean lists, reports, and imports. BEFORE YOU START Save a backup copy. Duplicate removal can permanently delete rows. STEPS Select the data range, choose the remove duplicates option, and select the columns that define a duplicate. CHECK RESULTS Review the remaining rows and compare counts before and after. CAUTION Rows that look similar may not be true duplicates. Decide which columns matter before removing anything.