Forum Discussion
Nicole_C
Mar 09, 2019Copper Contributor
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...
- Mar 09, 2019Press Alt,A,V,V, then select list. In the source box, type:
Onsite,Delivery
Press Enter and it’s done.
Nicole_C
Mar 09, 2019Copper Contributor
yes 1 of 2 options - Onsite or Delivery
Twifoo
Mar 09, 2019Silver Contributor
Press Alt,A,V,V, then select list. In the source box, type:
Onsite,Delivery
Press Enter and it’s done.
Onsite,Delivery
Press Enter and it’s done.
- Nicole_CMar 09, 2019Copper Contributor
Thank you so much! I'm looking into an online course for Excel so hopefully it will cover more than just the basics.
- TwifooMar 09, 2019Silver ContributorIf my answer returned your expected result, then indicate so to terminate this conversation.
If you have another question, you must make another post. Relative to your search for an online course, I won’t recommend any.
The result you want should dictate the skill you need to achieve it. There’s no logical basis on which you should learn something you don’t need anyway.
For a start, you must know what results you want to achieve. Post each one here and you will surely be apprised of the best way to achieve it. Such a way may come from me or from the esteemed experts in this community.- Nicole_CMar 09, 2019Copper Contributor
Yes, your answer was correct. Thank you.