HOW DO I SET UP DROP DOWN CELLS TO AUTO FILL AS I START TYPING IN.

I have dropdown cells set up which draw from a list on another worksheet, I
am trying to set it up so that when I start to type within the cell it will
strat filling from the list.

if you have a list hidden directly above your input cell as you type excel
will fill in from the list above.
--
paul
paul.shepherd@nospamparadise.net.nz
remove nospam for email addy!



"Trenner" wrote:

> I have dropdown cells set up which draw from a list on another worksheet, I
> am trying to set it up so that when I start to type within the cell it will
> strat filling from the list.

Hi Trenner,

Have a look at Debra's pages:

The start (for background info),
http://www.contextures.com/xlDataVal01.html

useful page,
http://www.contextures.com/xlDataVal10.html

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...