To do so, kick off the sheet you would like to create your dropdown list in.
go for the cell you want to add your list to.
Then, tap on the Data tab in your ribbon menu and select Data validation.
The data options
A new window will open.
Alternatively, you’re free to slide in your own list items, separating them with commas.
The validation options
When youre happy with that, you might add a few more functions.
you might add validation options.
This isnt exclusive to dropdown lists and can be applied to any field.
Validation checks to verify if the data in the field matches the requirements.
When you are happy with your selection options, tap the save button.
you could now make your edits.
To delete it entirely, tap on the remove validation button.
