Select a cell — I selected B2. Click the Data tab. In the Data Tools group, click Data Validation, and then click Data Validation from the dropdown. From the Allow dropdown, choose List.

Try clicking head-on images of just the data to minimize the errors while using the Data from Pictures feature. Moreover, well-lit images with little to no blur turn out error-free much of the time.

Click an Excel worksheet cell that you've linked to a drop-down list. For example, if cell E1 displays a drop-down list when you click it, click that cell to select it.