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.
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.