How Data Validation Works In Excel?
Data Validation is a feature which is used to avoid an entry of invalid data. Data Validation Select Data > Go to Data Validation Settings Tab Click on the Settings Tab >Allow > Select any option Input Message Input Message Tab > Customize Message Error Alert Enter an invalid Data > Error Alert appears