Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I would like to be able to start typing a name from avery long list and have
excel help me. If I start with the letter 'A' is shows the choices if I type an 'R' next it will reduce my choices etc. Is this possible in excel? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi!
Probably not what you had in mind but......... If you create a sorted list like this: A Abbot Allen Anderson B Belle Bender Black C Charles Clark Cullen Then create a drop down list from the above list....... Type C in the drop down cell AND DO NOT hit enter, rather, click the drop arrow, the list will automatically scroll to the C selections. Biff "madisonville" wrote in message ... I would like to be able to start typing a name from avery long list and have excel help me. If I start with the letter 'A' is shows the choices if I type an 'R' next it will reduce my choices etc. Is this possible in excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
missing cell borders in Excel | Excel Discussion (Misc queries) | |||
How do I create a List in Excel 2000 | Excel Worksheet Functions | |||
How can I copy a list from word into a single cell in excel | Excel Discussion (Misc queries) | |||
How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions | |||
Ooh .. Linking a list to a list to an output cell | Excel Discussion (Misc queries) |