We can expand on the Table topic, because if you add a data validation drop-down to the first cell in a Table, Excel will extend the drop-down to each new record.