Now, let’s insert the data validation control. Using the simple demonstration sheet shown in Figure A , click B2. Feel free to use one of your own files if you like or choose another cell.

Now we have a drop-down list created by Data Validation. Launch Excel. Add data into the spreadsheet. In this tutorial, we have added data to worksheets one and two.

Go to Data on the Ribbon, and in the Data Tools group, choose Data Validation. The Data Validation window that pops up allows you to set your criteria in many ways. For our example, choose Whole ...

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 .

Click "Data Validation" on the Data tab and click "Data Validation." Choose "List" in the Allow box. Type your list items into the Source box with a comma between each item. Click "OK" to add the ...