How to Prevent Duplicate Entries in Excel?

Duplicates would be one of the reasons for wrong data entry. So, how should we prevent duplicate entries in Excel when entering data? Let’s take an example. Here is a school report. Now we need to prevent duplicate names in the Name column. Highlight the name column and go to the Data tab. Choose Custom […]