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.