Create simple drop-down lists
To create a simple drop-down list in Excel with a fixed range, select the cell in which you want to display the drop-down list.
Then, click on the menu Data in your workbook, and click on the option Data Validation.
Go into the tab Settings and select List in the Allow drop-down list. Then, you can select the range that you want to display in your drop-down list in Source. Note that you can only select a range from the same workbook of your future drop-down list.
You can see in the above picture that a drop-down list with the range C3:C5 will be created when you click the button "OK".
If you modify values in the range (here in C3:C5), the drop-down list will automatically be updated with new values in the fixed range.
Create dynamic drop-down lists
To create a dynamic drop-down list in Excel, first you have to define a name to your dynamic range. To that end, click on the Formulas tab, in the Defined Names group, click Name Manager. You can choose a name and a dynamic range refers to your name in the section Refers to.
In this example, "ID" is the name chosen, and "ID " refers to MM_COLUMN(B4).
It means that the column of the grid, starting with cell B4, refers to the name "ID".
The next step is the same as the method to create a simple drown list, except the fact that in Source in Data Validation, you have to enter the name created in Name Manager. In this case, "=ID" will be written. Thus, when adding values to your range in the sheet, "ID" will automatically take into account the new value in the column of ID. It is particularly useful if the size of your column can vary. Content of your drop-down list will then be updated.
Display in Mind
As in Excel, drop-down lists are updated automatically when values of your range is modified in Mind. In the case of a dynamic drop-down list, it is updated automatically even if you add values to your range in Mind.
