Question: how do you create a drop down formula in excel?
Answer: Create the list in cells A1:A4. ...  Select cell E4. ...  Choose Validation from the Data menu. Choose List from the Allow option's drop down list. ...  Click the Source control and drag to highlight the cells A1:A4. ...  Make sure the In-Cell Dropdown option is checked.