5+ How To Make In Excel A Drop Down Menu Trending. Click on the ok button, as shown in the screenshot below. How to make a drop down list in excel:
In the source box, enter the reference. The data validation window will appear. In our example, the options are the cities listed.
After That, Go To The Data From The Data Tools Group, Click On Data Validation.
In the example, create a list of fruits, nuts, and vegetables in a worksheet. In your excel workbook, select the cells that you want to apply the drop down menu to. From the data validation dialog box, select list in allow field.
This Section Describes How To Set Up The Dependent Dropdown Lists Shown In The Example.
The “new name” window opens. To do that, click on cell e9. And in the source field, provide three types of compound interest.
Next, Navigate To ‘Data’ Tab In The Excel Ribbon And Then Click The ‘Data Validation’ Button.
The data validation window will appear. If it’s ok for people to leave the cell empty, check the ignore blank box. In the ‘allow’ dropdown, select the “list” option.
Select “List” And Link The Data.
Select a cell in which you want the dropdown to appear (d3 in our case). In the data tools section of the data tab, click the “data validation” button. Second, click on the data tab on the ribbon.
When The Data Validation Dialogue Box Appears, You Will Need To Select “List” Where It Asks You What You Want To “Allow” In The Cell.
In the excel ribbon, click the data tab. Click “name manager” in the formulas tab of excel. Create the lists you need.
