Web select the cell or cells where you want to create a dropdown list.
How to insert drop down menu in excel cell. In the resulting dialog, make sure the my table has headers option is selected, and click ok. Web simply click any cell in the list and press ctrl + t. On the data tab, in the data tools group, click data validation.
Select the cells that you want to. The dropdown lists in excel are created using data validation. I usually like to put.
On the ribbon, click data > data validation. I am an excel user like you. Web select one or more cells for your dropdown (d3:d7 in our case).
In the menu, under the components section, click “ dropdowns. at the top, click. If this doesn’t work for you immediately, click the box marked. Web in the excel ribbon, click the data tab.
Go to the data tools group from the data. Select the cells that you want to contain the lists.