Creating the drop-down list in Excel Cells is the most commonly used. We can prevent invalid entry by forcing the user to select value from the drop-down list which we have given. It is useful to data entry process.
Below are the steps to create a drop-down list in data validation:
- Select the range.
- Go to Data tab>>Data Validation>>Click on Data Validation.
- Below given window will be opened.
- Select List in Allow drop down.
- Put the comma separated text in the Source box.
- Click on OK button.
As we have put drop down for Yes, No and NA. It will be appeared in cells for which we have applied.
If we will try to enter anything else in cell, it will show the below error.
We can give the Source from the excel range or Name.
We have days name on range “F1:F7”. We can put it in the Source box.
Day’s name drop down will be created.
If we will enter anything else apart from this list, it will show below error.