Question

...create a dropdown list of textual entries​

Answer 1

Answer:

In the Data Validation dialog box, uncheck the Show error alert after invalid data is entered box under Error Alert tab, then click the OK button. Then you can enter any text into drop down list cells as you need without getting an error alert.

Hope it's helpful to you

Have a great day ahead