How To Create Drop Down List Excel. In the allow drop down menu we have to choose list option. Read on to see how to create dependent dropdown lists in excel.
In the ‘allow’ dropdown, select the “list” option. Now, a ‘data validation’ window will open. In the ribbon, select data > data tools > data validation.
In The “Source:” Box, Enter In Your Values Separated By Commas.
Select a cell in which you want the dropdown to appear (d3 in our case). You will get the dialogue box which will show validation criteria. In the “source” input type “=genre”.
If The User Selects Fruit, They See A List Of Fruits, If They Select Nut, They See A List Of Nuts, And If They.
The data validation dialog box displays. The steps to create named ranges are listed as follows: Enter your list in the source:
The Dialog Box Minimizes To Make The Sheet Easier To See.
The data validation window will appear. Select “data validation” in the “data tools” section. Click in the source box, and then on your sheet, select your list of valid entries.
Place The Cursor In The Source Text Box.
Select the database column from b2:b8. Go to the “data” tab in the ribbon. Select the “new” option in the “name manager” window.
First Of All, Change Your Normal Range Into A Table.
In the data validation dialog box, do the following: After free installing kutools for excel, please do as below: Click ok to save the data.