When you update the list at the table (sheet) level, Excel will automatically update the list in the drop-down. Now, let’s add the drop-down list and populate it with the list of color names in ...

We’ll create two Excel drop down lists based on this simple data set. We need two Excel drop down lists. The first Excel drop down list will set the condition, the region.