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.

edit delete
are you sure?
asked Pete rohrig

1 answer

enter link description here

edit delete
are you sure?
answered Lynette Spicer

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions