Microsoft Excel worksheets are convenient places to store limited amounts of data. Excel is a spreadsheet application, but an Excel file can also serve as a database for your website if you can ...

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 .