Browse » Home
Monday, August 27, 2012
How to Create a Drop
1. Select the data you want the drop-down menu to contain. This can be any list of information. Highlight those cells and click the 'Data' menu. Select 'Sort' and 'A-Z.' This will alphabetize your list.
2. Place your cursor in the cell where you want your drop-down list located. Click the 'Data' menu and the 'Data Tools' menu. In the 'Data Tools' menu, select 'Data Validation.'
3. Choose 'List' in the 'Allow' menu of the 'Data Validation' dialog box. Click the arrow beside the 'Any Value' option to view the options where 'List' will be found.
4. Click the button at the very end of the 'Source' entry box. This will generate a 'Data Validation' dialog box. Select the worksheet where the data is located for your list. Highlight all of the cells you want included in the drop-down list. Click the button at the end of the 'Source' entry box to select the cell range. If you do not want the list to be left blank, you should clear the check mark in the the 'Ignore Blank' check box in this menu.
5. Select the 'Input Message' tab to set an input message that will appear when the list is selected. This will allow you to provide people with an understanding of what you would like them to select in this menu.
6. Select the 'Error Alert' tab to set an alert to notify users if they have improperly populated the list or failed to select an option.
7. Select 'OK' to populate and publish the drop-down list.