Web simply click any cell in the list and press ctrl + t.

How to insert drop down menu in excel cell. The dropdown lists in excel are created using data validation. In the resulting dialog, make sure the my table has headers option is selected, and click ok. On the ribbon, click data > data validation.

I am an excel user like you. Web in the excel ribbon, click the data tab. Web select one or more cells for your dropdown (d3:d7 in our case).

I usually like to put. Choose the data validation option. If this doesn’t work for you immediately, click the box marked.

In the menu, under the components section, click “ dropdowns. at the top, click. Go to the data tools group from the data. Select the cells that you want to contain the lists.

Select the cells that you want to. Web select the cell or cells where you want to create a dropdown list.