How to Add a Listbox to an Excel Spreadsheet
- 1). Launch the Excel spreadsheet. Open a blank spreadsheet. Double-click on a cell.
- 2). Open "Data Validation". Choose "Data." Select "Validation." The "Data Validation" window will appear. Hit the "Settings" option.
- 3). View the drop-down box entitled "Allow." Choose "List". The boxes for "Ignore Blank" and "In-cell" need to be checked. Add whatever data you wish. Click "OK." Click the drop-down arrow. Your list box now will be visible.
Source...