In Excel, it may make sense to create a drop-down list that is based on a data source and also adapts dynamically instead of creating a very long list in rows or columns.