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

Gord Dibben MS Excel MVP

On Tue, 30 Mar 2010 08:51:02 -0700, Maanu
wrote:

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?

"????? (????) ?????" wrote:

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


"Maanu" wrote:

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

"????? (????) ?????" wrote:

'Tools' 'Options...' 'Edit' tab check 'Allow Auto-fill of cell values'
'OK'
Micky


"Maanu" wrote:

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!