Answer:
To create a list of the cells A2 to A12, convert the A2: A12 range to a table, then select the data validation tab, input list as the type and the name of the A2:A12 range table, and then click ok. This list can now be used as a validation list in another column or worksheet.
Step-by-step explanation:
Microsoft Excel provides the power of tables and list for categorized data and data validation.