How to Create a List Box in Microsoft Excel


Microsoft Excel is a spreadsheet application available as part of the Office Suite. The software is used by individual or business users. The software is used to keep track of records for applications such as finances, inventory and contact history. One way to normalize information is to create a list box. List boxes contain only a certain amount of entries. The user chooses from the list box to propagate the data in the Excel worksheet. You can create a list box using the data tools in Excel.

  • Double-click the Excel spreadsheet you want to alter. This loads the spreadsheet and the Excel software at the same time.

  • 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.

  • 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.

  • 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.

  • 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.

  • Click the list box arrow to view the information. This shows you all the values and tests the list box functionality.

Related Searches


  • Photo Credit Siri Stafford/Digital Vision/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!