Table of Contents
How do I create an if/then drop-down list in Excel?
Create the Drop Down List
- Select the cell(s) where you want the drop down list of customers.
- On the Ribbon, click the Data tab, then click Data Validation.
- In the Data Validation dialog box, under Allow, select List.
- In the Source box, type an IF formula that refers to the active cell, and the named lists.
How do I apply conditional data validation in Excel?
Steps in Using Conditional Data Validation
- On the second sheet, create the named ranges shown in the table below.
- On the first sheet, select cell B1.
- On the Data tab, in the Data Tools group, click Data Validation.
- In the Allow box, click List.
- Click in the Source box and type =Main.
- Click OK.
How do I assign a value to a drop-down list in Excel?
To set default value for the drop down list, you need to create a general drop down list first, and then use a formula.
- Create a drop down list.
- Then in the Data Validation dialog, under Settings tab, select List from Allow list, and then select the value you want to show in the drop down list to Source textbox.
How do you create a drop down list in Excel with multiple lines?
Here’s how:
- Select the drop-down cell and press Ctrl + C or click Copy on the ribbon.
- Select the destination cells.
- Right-click the selected range, and then click Paste Special… .
- In the Paste Special dialog window, choose Validation and click OK.
How do I create a drop down list in Excel with multiple options?
To create the drop-down list:
- Select the cell or cells you want the drop-down list to appear in.
- Click on the Data tab on Excel’s ribbon.
- Click on the Data Validation button in the Data Tools group.
- In the Data Validation dialog, in the Allow: list select List.
- Click in the Source: box.
How do I create a conditional drop-down list?
Creating a Dependent Drop Down List in Excel
- Select the cell where you want the first (main) drop down list.
- Go to Data –> Data Validation.
- In the data validation dialog box, within the settings tab, select List.
- In Source field, specify the range that contains the items that are to be shown in the first drop down list.
How do I create a drop-down list in Excel 2016?
Select the cell in the worksheet where you want the drop-down list. Go to the Data tab on the Ribbon, then click Data Validation. On the Settings tab, in the Allow box, click List. If it’s OK for people to leave the cell empty, check the Ignore blank box.
How do you do drop downs in Excel?
Create a drop-down list
- Select the cells that you want to contain the lists.
- On the ribbon, click DATA > Data Validation.
- In the dialog, set Allow to List.
- Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.
How do I link a cell to a drop down list?