Create the list in cells b2:b5.

How to create a quick drop down list in excel. Set up the list first. Please note that there’s more than one way to create a d. The data validation window will appear.

On the data tab, in the data tools group, click data validation. On the ribbon, click data > data validation. In the data validation dialog.

Web how to create drop down lists in excel 1. To do this, first and foremost, click on the developer tab. The automatic form feature of excel is often overlooked as you.

Web select a cell in which you want the dropdown to appear (d3 in our case). Web so, if you cannot delete the entire row because it will affect your other table data, you can remove the text in the cell and then move the remaining items up to fill the. Select the cells that you want to contain the lists.

Web on the ribbon, click data > data validation. In the dialog, set allow to list. Follow the steps below to be able to do that.

📌 steps first, enter the following formula in cell e5 in.