How to Remove duplicate in Excel

  How to Remove duplicate Elements in Excel Spreadsheet 

In Excel Spreadsheet, we can remove the duplicate elements the process is as follows

Step 1: Select the data to be removed duplicate elements

  Shortcut key - Ctrl + A

Step2 :

Click on Data in Menu and select Remove duplicates

Shortcut key - Alt + A +M

Step 3:

Select which column duplicate elements need to be removed

Here I have selected both columns

Step 4:

After selecting required columns click on OK

Successfully duplicate elements removed from the Selected Columns