How to prevent Duplicate Email and Phone Entries in Excel

How to prevent Duplicate Email and Phone Entries in Excel

How to prevent Duplicate Email and Phone Entries in Excel Αποφυγή διπλότυπων καταχωρήσεων ηλεκτρονικών διευθύνσεων αλληλογραφίας και τηλεφώνων Step 1 Mark All Email Cells except title. Do that before any data entry. Go To Data > Data Validation > Settings…