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 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 .

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 ...