How to remove duplicate records in excel in one click 2025

To remove duplicate records in excel is a tough job for beginners. You will learn to remove duplicate entries in excel easily.

When you do a lot of work on Microsoft excel and assignments come to you to sort the list by removing the duplicate entries in the excel sheet. If you were a beginner, it is going to be very tough for you to do. You will try to connect with your close colleagues for help.

Table of Contents

How to remove duplicate records in excel in one click?

When you found helpless to them, you would also communicate with your class friends. At last, when you find yourself totally helpless, you try googling. You are here for that reason and may be matched with this reason. You have to serrate unique values from the given list.

How to remove duplicate records in excel in one click 2025

Today, I am describing the good procedure to remove duplicate records from the excel sheet and retain the unique records. You may use excel’s own functions and formulas for this task but it will take and require some basic skills of Microsoft excel. You should know the excel formulas for removing duplicate entries and to remove duplicate records in excel.

I am not an expert in excel but believe me, everyone in my office requests me to do help with such type of task. Dears, I have just installed a plugin or addon for excel which do the task in just one click.

I also suggest you install it into your computer to make your life easy related to excel. Once, you have installed it into the system, don’t worry about the work burden. Its lower the task burden of excel and make your life easy feel. This plugin named is Kutool For Excell. It’s a fantastic plugin and works like a Jadoo which means magic.

Kutool for excel plugin for Microsoft Excel

This is the extended office product which really extends the office for the fast task. This is a tiny and small plugin nearly 15 to 30 MB in size. But its task is very different and quick compared to excels own built-in functions. You may do everything with the help of excel. I have already posted about it and Downloaded it. You may go there for installing a complete software of excel task solutions to remove duplicate records in excel. Also, see How to make PDF files on a computer?

How to remove duplicate records in excel from one excel sheet using kutool for excel software?

As I already said that it works with just one click. There, you have one file sheet that have mixed data with duplicate entries also. Now, you want to remove duplicate entries from the sheet. Kindly follow the below step to remove duplicate entries or remove duplicate records in excel.

Kutool for Excel must be installed in your system. If you already do not have one, click here to get into your PC.
Open your excel datasheet which you want to simplify by removing duplicate entries.
Now, you will select the column or row in which you have duplicate records. There will be numeric, alpha and alphanumeric records. Always choose the same type of data. In my case, I have the unique data I’d of CNIC which I want to remove duplicate records of CNIC.
When you select the column containing unique values, click on kutool tab.
Now, select the drop-down button “Delete” and choose “Delete Duplicate or Unique Value”.
Below it, choose the colour to easily identify the searched duplicate records. Select any colour of your own choice. It is the two colours; one will change the text colour of duplicated values and see one will fill the cell background colour. Select the background colour and tick on it to remove duplicate records in excel.
A dialogue box will be shown to you containing the different scenarios and checkmarks. Choose a checkmark on “Duplicate including the First row”. And click the ok button.
It will scan all the columns and finally show you the total duplicate found records. Click OK to delete.

Congratulations you have successfully deleted duplicate values.
This option is not available in the below 24 versions of kutool. So, Download the above version if you utilized this function.

How to remove duplicate records in excel sheet using the excel built-in function power query?

Open your excel sheet that you want to remove duplicate records in excel.
Click the cursor on any cell and press CTR+T from the keyboard.
Create table box will be appeared and click on the ok button. It will create your data in the table.
Then, it will auto take to you into the design tab and select the table style from the left side of the top.
Now, click on the Data tab and select the “From Table” option from the get and transform tab.
It will open the power query page where you easily remove duplicate entries.
Now, you will see a table sign from the first column above the numbering. Click on it and select “Remove Duplicate”. It is better to select your column or may not need to select it.
You have deleted duplicate values.
Now, click on the “close and load” button and choose the “close and load to” option.

It will open a pop-up page; these are the settings where you want to place the new unique data. Select the table if you want to insert unique new data into a new table and sheet otherwise select the second option. Select as you want.
After deleting the duplicate, you may select all and copy the entire date and may paste it into a new sheet manually.

Hope you will easily remove duplicate records in excel with one click.

You May Also Join Us On: