Forum Discussion
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 functions that do a lot more than what I'm asking. Can anyone help? Thanks.
- Press Alt,A,V,V, then select list. In the source box, type:
Onsite,Delivery
Press Enter and it’s done.
9 Replies
- After the user selects an option from the drop-down list, what do you want to happen next?
Your desired result shall dictate what formula to use.
The formula may use a myriad of combinations of functions, which all return your expected result.Actually, nothing needs to happen next. Its just a shortcut for me to be able to select what type of catering contract I need to provide. In other words, its just informative., if that makes sense.
- Do you mean that you want to create a drop-down list wherein the user may select 1 of 2 choices?
