In the Data Tools group, click Data Validation, and then click Data Validation from the dropdown. From the Allow dropdown, choose List. For Source, enter =Animals_List, as shown in Figure C .

Image: IB Photography/Adobe Stock. If you work with imported or foreign data in Microsoft Excel, chances are you have to clean the data a bit before you can use it.

Merging data from multiple Excel files can be a time-consuming and error-prone task, but Excel’s “Get Data” feature simplifies this process. This tool allows you to combine data from various ...