DropDown aand Auto Fill
 

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!

DropDown aand Auto Fill
 

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!

DropDown aand Auto Fill
 

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!

DropDown aand Auto Fill
 

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!

DropDown aand Auto Fill
 

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!

DropDown aand Auto Fill
 

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!