Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pre-fill cell by typing first few letters of a list
I have created a list and have set the cell validation to pick from the list.
I want to be able to just type in the first letter and have the cell pre-fill with the first item in the list matching the typed letter and keep pulling if I hit the same letter again. (i.e.-My list contains Cat, Corn, and Cupid. When I am on a cell with the validation set I type a C and it automatically fills in Cat, if I hit C again it goes to Corn, again and it goes to Cupid. It would then wrap around to Cat again if I continued to hit C) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pre-fill cell by typing first few letters of a list
Not exactly what you've asked for, but very close:
http://www.contextures.com/xlDataVal10.html Instead of jumping from Cat to Corn to Cupid, it will auto-fill based on what you type: Ca - will come up with Cat Co - would go to Corn Cu - gets you to Cupid. Debra has some good routines for doing this type of thing, and others 'tricks' with lists. "Trying to learn!" wrote: I have created a list and have set the cell validation to pick from the list. I want to be able to just type in the first letter and have the cell pre-fill with the first item in the list matching the typed letter and keep pulling if I hit the same letter again. (i.e.-My list contains Cat, Corn, and Cupid. When I am on a cell with the validation set I type a C and it automatically fills in Cat, if I hit C again it goes to Corn, again and it goes to Cupid. It would then wrap around to Cat again if I continued to hit C) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can excel choose a name from a list when I am typing in a cell | Excel Worksheet Functions | |||
HOW DO I SET UP DROP DOWN CELLS TO AUTO FILL AS I START TYPING IN. | Excel Discussion (Misc queries) | |||
Can I auto fill a cell in one worksheet by typing a code number | Excel Worksheet Functions | |||
Speed Search in pick list by typing only first few letters | Excel Discussion (Misc queries) | |||
I need help getting Excel to auto-fill cells when I begin typing . | New Users to Excel |