 This is the easiest way to create a dynamic dropdown list in Excel. First, select the range containing your desired values, go to the Insert tab and convert your range into a table. Once you've done that, you'll then need to select the range in which you want your dropdown list to appear. Then go to the Data tab, Data Tools and finally select Data Validation. We've got two dropdowns here. The first one we just need to select List and in the second one for Source, we're now going to select that single column in our table, which contains our values and then we should select OK. You can now see a dropdown list has been added to the range previously selected and we're able to now select all of the valuable values in our table. The real benefit of doing it this way is as more values are added to that column in the table we've created, these values will now also appear in your dropdown list. You've now got that dynamic solution to either add new values or remove them from your list. Please don't forget to hit that like button if you enjoyed this video.