How to Restrict duplicate entries & Prevent Duplicate Entries in Excel

In this We have Learn How to Restrict duplicate entries & Prevent Duplicate Entries  in Excel.

1. Select the cell which you want to Restrict Duplicate .

2. On the Data tab, in the Data Tools group, click Data Validation.

3. In allow option, select list & in source option  select the range which you want to restrict  the cell.

4. click on OK button &try to enter duplicate entry.

For More Details please See the Video