Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lists (Drop down Box)
I have a product list of about 200 items. Is there an easy way to bring up
the items by the first letter of a product. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lists (Drop down Box)
Assuming you're using a data validtion list.
The easiest least involved way: Sort your source list and add the first letters needed: A Adam Allan Amanda B Becky Ben Bert C Connie D Danny David Then, in the cell with the drop down type the first letter but *don't* hit enter, instead, click the drop arrow and the list will "scroll" to the letter. There are other methods that are less clunky *but* they're more involved if you need to use the selection in a formula. -- Biff Microsoft Excel MVP "Doug" wrote in message ... I have a product list of about 200 items. Is there an easy way to bring up the items by the first letter of a product. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lists (Drop down Box)
You could apply Data|filter|autofilter (in xl2003 menus) to that column.
Then use a custom filter--begins with X Doug wrote: I have a product list of about 200 items. Is there an easy way to bring up the items by the first letter of a product. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Lists | Excel Discussion (Misc queries) | |||
How do I ??? - two drop down lists | Excel Worksheet Functions | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions |