Remove Duplicates in Excel Office 365 – Simple Instructions!!
Tags: excelpreface, removeduplicatesinex, exceltutorials
Published: 2020-12-15 10:57:20

---
title: Remove Duplicates in Excel Office 365 – Simple Instructions!!
published: true
date: 2020-12-15 10:36:44 UTC
tags: ExcelPreface,RemoveDuplicatesinEx,ExcelTutorials
canonical_url: https://geekexcel.com/remove-duplicates-in-excel-office-365-simple-instructions/
---

If you have a huge data about student marks list in the Excel spreadsheet, and you want to remove the duplicates from it, what will you do? That’s why we are here to help you to resolve your queries/issues. To remove only the duplicate data from the worksheet, you can use the **Duplicate Remover Toolkit** of [Ablebits.com](https://www.ablebits.com/) This add-on will help you to finish the work quickly.

In this post, we are going to see how to **Remove Duplicates in Excel Office 365** with the best practical example.
## Things that can do with **Duplicate Remover Toolkit:**

**Search for Duplicates in One Table:** You can find all duplicates in the worksheet with or without the first occurrences.

**Compare Two Tables for Matches & Differences:** It will check for differences or matches in two Excel columns, lists, or tables.

**Remove Dupes in a Flash:** With this option, you can easily remove dupes in the table with one single click.

**Choose One or Several Columns for Comparison:** If you search for the duplicates in one sheet or compare two tables, you need to choose any number of key columns to check.

**Delete Duplicate Rows:** You can identify and remove the repeated lines that have the same value in one column or in all selected columns.

**Find Unique and Distinct Values:** It is used to check for unique data only or include the first instances of repeated values in your search.

**Highlight & Select Dupes and Unique Cells:** You can get duplicates or unique entries automatically selected or highlighted with any color of your choosing.

**Move Duplicates or Copy Unique Cells:** It is also used to copy the unique cells and move repetitive values to a new sheet.

**Identify Matches & Differences in a Status Column:** You can easily add a column with status marks to view duplicates and unique values.

**Deduplicate Excel Tables of Any Size:** This tool can process worksheets with any number of columns and up to one million rows.

## Steps to Remove Duplicates:

- For instance, here we have shown the students mark list and their rank, grade, total. We are going to delete the duplicate values from this range.

![Example range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-range.png)<figcaption id="caption-attachment-19743">Example range</figcaption>

- Then, on the **Ablebits Data Tab,** you need to **click** the **Duplicate Remover** drop-down list.
- You need to **select** the **Duplicates Only** option from the menu.

![Ablebits Data Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Ablebits-Data-Tab.png)<figcaption id="caption-attachment-19736">Ablebits Data Tab</figcaption>

- Now, it will display the **Duplicate Remover – Step 1 of 4** Dialog Box.
- You need to **select** the **data range** using the browse button and **click** the **Next** button.

![Select the data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-data-1.png)<figcaption id="caption-attachment-19737">Select the data</figcaption>

- Then, it will move to the **Step 2 wizard** as shown in the below image.
- You need to **check** the **Duplicates** option and **click** the **Next** button.

![Click the Next button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Click-the-Next-button.png)<figcaption id="caption-attachment-19738">Click the Next button</figcaption>

- Now, it will move to the **step 3 wizard** , where you need to **select** the **columns** that you want to remove the duplicate values.
- Then, **hit** the **Next** button.

![Select the key column](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-column.png)<figcaption id="caption-attachment-19740">Select the key column</figcaption>

- It will move to the **Step 4 wizard**.
- You need to **select** the **Highlight with color**  option under the **Choose the action** section.

![Choose the action](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-26.png)<figcaption id="caption-attachment-19751">Choose the action</figcaption>

- Finally, **click** the **Finish** button to get the result.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/chrome_EMSUfQWMOU.png)<figcaption id="caption-attachment-19750">Prompt box</figcaption>

## Verdict:

In the above post, we gave detailed guidelines to **Remove Duplicates in Excel Office 365** using Ablebits.com with the best practical example. Kindly, drop your **suggestions/feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!