How to remove duplicate data in Excel?
Step 1: Collecting/getting the data.
|Duplicate entries in the Data column of the data table with values.|
In the column named ‘Data’ you can observe the duplicate entries highlighted in yellow.
Step 2: Select the column containing the data.
|Selecting the column in which we have to remove the duplicate entries.|
You can select the column by clicking at the top of the column or you can select manually.
Step 3: Go to Excel Menu Bar and Find ‘Data‘ option the menu bar.
Click on the data tab and you will see all the tools available under the tab.
Step 4: Go the “Remove Duplicates” option available in the data tab.
See the icon carefully as you can recognize it whenever required. Click on the option.
Step 5: After launching the option you will be prompted to a warning message.
|A warning message has two options.|
Expand the selection:
As you can observe, we have removed the duplicate entries from the Column ‘Data’ and also the corresponding values of the required entries are not disturbed too.