How to Use a List Box in Excel

1. Select the cells on which you want to use the current list box.
2. Click 'Data' from the top menu; then select 'Validation' from the drop-down menu.
3. Select 'List' from the Allow drop-down menu.
4. Enter the data you want in the list boxes into the Source text box, separated by commas if you don't want to display options elsewhere on the worksheet.
5. Click the image of the grid with an arrow to take back to the spreadsheet, then highlight the data you want in the list box to create list box options from existing cells.
6. Check the 'In-cell Dropdown' box.
7. Press the 'OK' button to create the list box.