Drop-down lists are essential if you need to sort your data or create a pivot table. For example, Excel sees "Texas" and ... or change the source range to add or subtract items from your drop ...