Microsoft Excel provides many ways to organise and display data, one of which is the combo box. Combo boxes provide a drop-down menu, which affords users the ability to select which data they want to view. Making a combo box can save space in a spreadsheet and make finding specific data much simpler.
- Skill level:
Other People Are Reading
Open Excel on your computer, and open a new spreadsheet. Somewhere in the spreadsheet, enter the data that will appear in the combo box. For example, you might enter data between cells C4 to C10.
Go to the "Forms" toolbar, and select "Combo Box."
Drag your mouse over the cells that you want the combo box to encompass. Once you release your mouse click, the combo box will appear.
Right-click on the new combo box,, and choose "Format Control" from the menu. Specify the cell range of your data in the "Input Range" field; in the above example, you would enter C4:C10, because those are the cells that hold your data.
Go to the "Cell Link Box," and enter the number of the cell where you want the index value of items selected in the combo box to appear. Click "OK."
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for