Although you don't have to format your data as an Excel table, doing so will make life easier if you add more rows or columns, and Excel generally reads data formatted as a table ...

Microsoft Excel's Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, ...