Drop-down list selection

Copper Contributor

I can create a drop-down list and my Excel worksheet has 20 cells with drop-down lists.  I see that to access the drop-down list you have to click on the cell with an associated drop-down list which then creates a drop-down list arrow to the right of the cell. Then you have to click on that arrow to access the list. That's a 2 step process.  Is there any way to just click on the cell and have the drop-down list appear?  That's a one-step process. 

3 Replies

 

123748owbbndmb9tn7m683.gif

 

 

@pfwag 

How about a standalone picker like above image?

@peiyezhu  Thank you. Looks more like what I want.  How does one create it?