How To Make A Drop Down List In Excel Cell

From The Data Menu Click The ‘Data Validation’ Button (See Figure 4).

Select the second cell that you want to load list items for depending on what’s selected in the first cell. The drop down lists allo. On the data tab, in the data tools group, click data validation :

Next, Navigate To ‘Data’ Tab In The Excel Ribbon And Then Click The ‘Data Validation’ Button.

Auto populate cells based on dropdown box selection. Go to the “data” tab in the ribbon. This means your drop down list will now contain the values in the range you called “type”.

On The Data Tab, In The Data Tools Group, Click Data Validation:

Switch back to the worksheet where the form is beign creating; In the ‘allow’ dropdown, select the “list” option. Go to the data tab on the ribbon, then click data validation.

It Consists Of 5 Positions.

On the data tab, in the data tools group, click data validation. Now, a ‘data validation’ window will open. Create a conditional drop down list with classified data table.

Repeat The Process Above To Open The Data Validation Window.

It can be in the same worksheet or another one. First of all open your excel sheet and select the cell on which you wish to create a drop down. #2 go to data tab, click data validation command under data tools group.