Autopopulate a drop down list in Excel

[Guest]

I have created several drop down lists in Excel by using the Data Validation
Feature.
The problem I am having is that my drop down lists are very long and I would
like the cell to allow a user to just start typing one of the options in the
drop down and have it autopopulate if the option is listed in the drop down.
I already have my settings in Excle to autopopulate, and it does on any other
part of excel, just not the drop down boxes.

Does anyone know how to allow my drop downs to auto populate?
Thanks!!!

 

[Gord Dibben]

DV lists won't autocomplete.

You need a combo-box for that.

See Debra Dalglesih's site for instructions.

http://www.contextures.on.ca/xlDataVal10.html

 

[Guest]

Hi,

You could try this.

Do one of the following;

Procedure 1:

1. On the Tools menu. click Options. The Options dialog box is displayed.
2. Click the Custom Lists tab.
3. In the Column List list, Click New List
4. In the List entries list, click the cursor inside.
5. Type column names and seperate each name by comma.
6. Click the Add button. The new list entries are listed in the coulmn list.
7. Click OK to return to the Worksheet.
8. Now enter a column and then drag the cell. All the other column entries
automatically gets populated.

Procedure 2:

1. On the Tools menu. click Options. The Options dialog is displayed.
2. Click the Custom Lists tab.
3. In the Column List list, Click New List
4. In the Import List from entries, click the cursor, and the select the lis
of cells from the Worksheet.
5. Click the Import button. All entries are listed under the List entries
list.
6. Click OK to return to the Worksheet.
7. Now enter a column and then drag the cell. All the other column entries
automatically gets populated.

Challa Prabhu