Forum Discussion

Nicole_C's avatar
Nicole_C
Copper Contributor
Mar 09, 2019
Solved

How to implement a simple drop down list with 2 choices

Hi - I'm relatively new to Excel Functions.  I'm trying to create a column where the  user selects 1 of 2 options from a drop down list - Either Onsite or Delivery. The solutions I've come across are...
  • Twifoo's avatar
    Twifoo
    Mar 09, 2019
    Press Alt,A,V,V, then select list. In the source box, type:
    Onsite,Delivery
    Press Enter and it’s done.

Resources