View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן מיכאל (מיקי) אבידן is offline
external usenet poster
 
Posts: 561
Default 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!