Browse » Home
Saturday, March 19, 2011
How to Create a List Box in Microsoft Excel
1. Double-click the Excel spreadsheet you want to alter. This loads the spreadsheet and the Excel software at the same time.
2. Click a cell in which you want the list box to display. Click the 'Data' menu item in the main toolbar. In Excel 2007, click the 'Data' ribbon tab.
3. Click the 'Validation' menu option. In Excel 2007, click the 'Validation' button and select 'Data Validation' again. This opens a new window where you set the list box settings.
4. Click 'List' in the first window. This sets the type of drop down box for the cell. When the drop down type is selected, a text box is enabled. Click the arrow next to the text box. This opens a new window where you select the cells that hold the values for the list box.
5. Highlight each Excel cell with the values for the list box. When you are finished, press the 'Enter' key. The cell selection window will close. Click the 'OK' button. This closes the configuration window and the list box is created in the spreadsheet.
6. Click the list box arrow to view the information. This shows you all the values and tests the list box functionality.