In an Excel workbook you might have a worksheet that contains several lists that you use as the source for data validation dropdown lists. For example, this worksheet has a list of countries, and lists of regions within those countries.

If each list has a heading, you can quickly create named ranges from [...]