How to Create a Drop

1. Create the list of selections that you want listed in the drop-down box. Select a tab other than the one on which the drop-down box will appear. Type each selection in an individual cell. The cells in which the selections are listed should be sequential. For example, selections 'A,' 'B' and 'C' would be listed in cells A1, A2 and A3. A list of selections may also be created in the same tab on which the drop-down box will be created.
2. Select the cell in which you want to create the drop-down box. Click the 'Data' tab and locate the 'Data Tools' group. Select the 'Data Validation' option. This action will open a separate dialog window.
3. Click the 'Settings' tab on the Data Validation window. Select the 'List' option from the 'Allow' menu. Click the 'In-Cell Drop-Down' check box.
4. Click the 'Source' field. Click the tab that contains the list of options you created in Step 1. Click once in the first cell of the selection string and drag to the last cell while holding down the mouse button. Click the 'OK' button on the Data Validation window.