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!

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!

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!

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

On Tue, 30 Mar 2010 07:37:02 -0700, 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!

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!

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!