The above method is just fine to get started but imagine the scenario of creating a long list of value or your list of values changing every now and then, and then it will get difficult to go back edit the list of values manually, so by entering values in the cell we can easily create a list of values in excel. Click on “Ok,” and the list of values will appear in the form of the “drop-down” list.Once the first value to be validated is entered, we need to enter “comma” (,) as the list separator before entering the next value, so enter “comma” and enter the next values as “Not Agree.”.For this list, we can give a list of values to be validated in two ways one is by directly entering the values in the “Source” list.Since we are creating a list of values, choose “LIST” as the option from the “Allow” drop-down list. By default, the “Settings” tab will be shown, and now we need to create validation criteria.This will open the data validation tool window.
In the Excel worksheet under the DATA tab, we have an option called “Data Validation” from this again to choose “Data Validation.”.
0 kommentar(er)
