Drop down List without arrows

Drop down lists without arrows.

I have a spreadsheet created by someone else, there are multiple cells with drop down lists that can only be seen when right clicking the cell and selecting "drop down list". Also, when the cell is selected no arrow appears. I wish to re-create this action, how do I do this?

I've done the normal creation of drop downs using data validation but do not see how to re-create the above situation.

1 answer