Browse » Home
Thursday, June 23, 2011
How to Use Auto Complete in a Combo Box in Excel 2003
1. Launch the Microsoft Excel program on your PC computer and open the spreadsheet file in which you want to add a combo box.
2. Enter the values you want to use in the combo box anywhere on your spreadsheet. Use a separate cell for each value, but keep them together in a single column so that you can reference them later.
3. Go to the 'View' menu at the top of the window, expand the 'Toolbars' submenu and select 'Forms.' This will add several new elements to the main Excel toolbar, including the combo box.
4. Select the 'Combo Box' icon in the toolbar and then click on the area of your spreadsheet where you want to place the combo box item.
5. Hold down on the left mouse button and drag your pointer to the right to extend the size of the new combo box.
6. Right-click on the combo box you just created and choose the 'Format Control' option.
7. Fill in the 'Input Range' field with the location of the cells where you entered the desired autocomplete values in Step 2. Use a colon symbol to separate the first cell in the column from the last cell.
8. Press the 'OK' button to save the settings. As you begin to type in the combo box, Excel will autocomplete the text based on the values you have previously configured.