This article will show you how to automatically update your drop-down list
Create a dropdown list in Excel
To create a dropdown list activate the menu Data > Data Validation

- Select a cell (in our example F1)
- Select the menu Data > Data Validation
- In the dialog box, select the option List
- Then select the cells that contain your data
- Validate



Now your cell (F1) displays a small arrow. Click on it to display the list of the data selected.



But now, if you add new values in your source, they will not be display in your dropdown list.



The reason is simple. The range of cells of your dropdown list is still D2:D5 (and it should be D2:D6).
So, in order to create a dynamic dropdown list, we must use a Table, because with the tool Table, the range of data are dynamic.
Create a dynamic dropdown list
To make a dropdown list dynamic, use the Table tool.



- Select your data source
- Activate the tool Insert > Table
- Very important: Check the option My table has headers



- Re-open the tool Data > Data validation
- Change the source with the following formula:
=INDIRECT("Table1[Name]")



And now your data source is dynamic 😍😍😍



30/05/2021 @ 04:27
good job bro