Forum Discussion

Mattman's avatar
Mattman
Copper Contributor
Sep 20, 2021

Excel Drop Down Selections

I am working a form with a drop down menu as the first question. I am looking to see if there is a way in excel that based upon the user's selection on the drop down menu, can Excel make other cells appear if a certain option is selected?  

 

For example, if the form consists already consists of requested information like names, birthdays, favorite color, but if they want chocolate ice cream they more cells appear in the form that they need to fill out versus if they mint chocolate chip, they do not need to fill out anyhting and the form does not need to change. 

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    Mattman 

    If you’re looking to ask a question or start a conversation about Excel, you’re in the right place! Ask away.

    Please include the following info to help others answer your question

    Welcome to your Excel discussion space!

     

    Thank you for your understanding and patience

     

    NikolinoDE

    I know I don't know anything (Socrates)

     

Resources