Using an Excel Table within a Data Validation list

Excel Tables expand automatically whenever new data is added to the bottom. Data Validation lists would benefit from the auto-expand feature… but it just doesn't work.

This article shows you how to make a Data Validation list that refers to a Table, via three methods:

• Normal cell references over a Table.
• Named Range of the Table column.
• INDIRECT function.