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.