Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Box
Hello I need help with a spreadsheet project I would like to improve
on. I have a spreadsheet the spans many columns. What I would like to do is set up a drop down list of lets say items in each column example: column "A" has the word bear in cell a1 a b c d bear dog cat horse I want to make a drop down list that works like the "find function" so if I type be it will find the word bear in the correct column like is used on web pages for States hope I explained it well enough for you to understand what I would like to do. thank you Rob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Box
You can do data validation:
Data-Validation...- Select From: List - Select range Hit the drop-down arrow, and type the first letter/letters of your search term. "Rob" wrote: Hello I need help with a spreadsheet project I would like to improve on. I have a spreadsheet the spans many columns. What I would like to do is set up a drop down list of lets say items in each column example: column "A" has the word bear in cell a1 a b c d bear dog cat horse I want to make a drop down list that works like the "find function" so if I type be it will find the word bear in the correct column like is used on web pages for States hope I explained it well enough for you to understand what I would like to do. thank you Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing a list of data | Excel Discussion (Misc queries) | |||
List for AutoFilter and list for Subtotals have different meanings? | New Users to Excel | |||
Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
Creating a List based on your choice from Another List | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |