In this article, we have mentioned about how you can easily remove all duplicate values from rows and columns in MS Excel. This below-mentioned tips are simple and easy to use so that anyone can easily remove duplicate values from their excel sheet without any problem. By using these below-mentioned steps, you can also identify duplicate values, and you can remove them from your Excel sheet without any issue.
How To Remove Duplicate In Excel
You can follow the steps to remove duplicate values from your excel sheet.
Identifying duplicate values
If you want to identify duplicate values on your Excel spreadsheet before deleting the duplicate values from Excel sheet, then you can follow these below-mentioned steps to identify duplicate values.
Step 1: First of all, you will need to highlight the all data that you want to use to identify duplicate values.
Step 2: After that, you have to click on “Conditional Formatting” function, which you can find in the “Styles” section of the “Home” tab. After that, a drop-down menu will appear.
Step 3: Here, You have to select “Highlight Cell Rules” >> then click on “Duplicate Values” option, which you can find at the bottom of the pop-out menu.
Step 4: Once you clicked on Duplicate Values option, then this function will automatically highlight all the duplicate values in your select data range.
Let’s take a look at below mentioned few simple steps to remove duplicate in Excel:
In MS Excel, you will also get the built-in feature to remove duplicate values from rows and columns, which you can use to remove duplicate values from any Excel Sheet.
Step 1: First of all, you have to select of all the data that you can want to use to remove duplicate values. To select data or table, you have to press Ctrl and A keyboard keys at the same time (Ctrl + A).
Step 2: After you select the data on Excel sheet, you will need to click on “Data” tab which you can find on the top bar of the screen. Then click on “Remove Duplicates” button, which you can find under Data Tools group.
Step 3: Once you clicked on Remove Duplicate button, a small dialog window will appear on a screen. And you will notice that the header of your data has automatically been deselected. The reason of this that the “My data has headers” option is marked.
Step 4: If your data have no any header then you can deselect “My data has headers” option. And now, you will need to select all columns that contain the duplicate values.
Step 5: After that, just click on the “OK” button to delete all duplicate values from your Excel sheet. Once you clicked on ok button, the Excel will automatically remove the duplicate values from your spreadsheet.
You are done. You can also follow the step by step video guide below if you need further help.
We hope this tutorial has helped you, if you have any doubt in removing duplicate values from your Excel sheet, feel free to share your thoughts in the comments section below.