Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Drop Down Lists Help
I'm attempting to make a drop down list that selects one particular item and
will sort the excel spreadsheet by the selection. For example: If my list includes Fruit, Vegetables and Other, when I select 'Other' the only entries that show are 'Other'. Any suggestions? I've scoured the Microsoft Excel help pages without any luck. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Drop Down Lists Help
Laura
From what you say, I don't think you mean "sort". I think you mean Filter. For instance, say you have a table of names, addresses, state, phone numbers, etc. You want to see (filter) only those people from, say, New York. You would click on Data - Filter - Auto Filter. Each of the headers would now have a drop-down arrow. You would click the down-drop arrow to the right of State, if that is the header of the state column. A list would drop down showing every state in that column. You would click on New York. Immediately, every row would be hidden except for all the rows that have New York in the state column. Is that what you want? HTH Otto "LauraB" wrote in message ... I'm attempting to make a drop down list that selects one particular item and will sort the excel spreadsheet by the selection. For example: If my list includes Fruit, Vegetables and Other, when I select 'Other' the only entries that show are 'Other'. Any suggestions? I've scoured the Microsoft Excel help pages without any luck. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists in excel | Excel Discussion (Misc queries) | |||
Excel Drop-down lists | Excel Discussion (Misc queries) | |||
Excel drop down lists | Excel Discussion (Misc queries) | |||
Drop-down lists in Excel 2003 | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions |