How to remove duplicates in Microsoft Excel

While working in Excel sheets we get data in large amount to work. Sometimes it happens by mistake that our data is copied or we need to reconcile the data. It is very difficult of find duplicate data manually. It is hectic and time consuming. At this time “Remove Duplicates” can make our work easy. Let’s see, how does it works?

1. Select the data you want to remove duplicates from.
2. Click on “Data”.

3.Click on “Remove Duplicates”.

That’s it. Now duplicate content has been removed and you can work on your required data only, instead of wasting time searching it manually.