Make sure that the cell references are absolute (such as $A$2) and not relative (such as A2, or A$2, or $A2). Note: If you want to create a drop-down list in multiple cells at one go, select all the cells where you want to create it and then follow the above steps. This will create a drop-down list that lists all the fruit names (as shown below).
Here is how you can directly enter it in the data validation source field: You can also add items directly by entering it manually in the source field.įor example, let’s say you want to show two options, Yes and No, in the drop down in a cell. In the above example, cell references are used in the Source field. If this option in unchecked, the cell does not show a drop down, however, you can manually enter the values in the list. Make sure that the In-cell dropdown option is checked (which is checked by default).This will insert a drop down list in cell C2. In the source field, enter =$A$2:$A$6, or simply click in the Source field and select the cells using the mouse and click OK.As soon as you select List, the source field appears.
In the Data Validation dialogue box, within the Settings tab, select List as the Validation criteria.Go to Data –> Data Tools –> Data Validation.Select a cell where you want to create the drop down list.Here are the steps to create an Excel Drop Down List: Let’s say you have a list of items as shown below: In this section, you will learn the exacts steps to create an Excel drop-down list: Creating a Dependent / Conditional Excel Drop Down List.
DROP DOWN LISTS IN MICROSOFT WORD NOT WORKING ON MAC HOW TO
How to Select All Cells that have a Drop Down List in it.Caution while Working with Excel Drop Down List.Creating a Dynamic Drop Down List in Excel (Using OFFSET).How to Create a Drop Down List in Excel.