DropDown aand Auto Fill

[Maanu]

Hi,

I have column with DropDown List.. The items are

a. Documentation
b. Logic
c. Optimization

Is there a option to automatically fill a cell, if I type the first letter
of an item?

Also when I type alt+ down arrow the list appears. I would like to fill the
cell when the first letter of an item is typed.

Is that possible?

Thanks!

 

[Maanu]

I am using Excel2003. The ption is enabled in my machine. But the content is
not automatically filling..

 

[מיכ×ל (מיקי) ×בידן]

1) Try not to have any empty cells throughout the range.
2) Check the Auto-fill feature in the first empty cell below the last cell
of the range.
Micky

 

[Gord Dibben]

Not with DV list alone. DV has no Autocomplete fuction.

You have to utilize a ComboBox in conjunction with the DV dropdown.

See Debra Dalgleish's site for how-to.

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


Gord Dibben MS Excel MVP

 

[Maanu]

I do not understand this post and I do not know how to check Auto-fill
feature for a particular cell. Can you help me?

 

[Gord Dibben]

See my reply..............you cannot use autocomplete in DV dropdown lists.

Gord Dibben MS Excel MVP