top of page

How to remove duplicates in Excel | Xyclos

Actualizado: 21 dic 2022


How to remove duplicates in Excel | Xyclos
How to remove duplicates in Excel | Xyclos
  1. First, find duplicates values in a column, using Conditional formatting

  2. Click in the column you want to inspect

  3. Home/Conditional formatting/Highlight cell rules/Duplicate values...

  4. Then activate Filters

  5. Click on the column's filter

  6. Select Filter by color

  7. Select Filter by cell color

  8. Now you can delete duplicate rows with duplicated values

There is another option:

  1. Clic kon any cell of a list

  2. Go to Data tab

  3. In the group Data Tools, clic on Remove duplicates

  4. In the window Remove duplicates, click on Unselect all button

  5. Select the column where you think there are duplicates

  6. Click Ok button A window message is displayed with the results


#CursosOnlineMicrosoft #Xyclos #Microsoft #CursoDeExcel #CursoPowerBI #CursosdeProject #CursoOnline #Aprendizaje #CrecimientoLaboral #MicrosoftExcel #howtodeleteduplicatesinexcel #howtoremoveduplicatesinexcel

6 visualizaciones0 comentarios
bottom of page