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.

In Excel, the term for custom-designing the attributes of an image is called formatting. When an image is selected, the FORMAT tab appears, showing all the formatting options and features for that ...