| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter drop down lists
I am new to Excel and so please can you be very exact in any answers you
might be able to give to me please. I have made a database/spreadsheet and at the top of the columns I've put filter arrows. That's fine. I can use them but now I find that in the drop down lists all the data (in this case names) does not appear. Can anyone tell me why, and how I can make them all appear in order to use them? Thanking you, -- anneten |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filter drop down lists
The filter pull-down can only display up to 1000 distinct items. There
are ways around this, as discussed in this link: http://www.contextures.com/xlautofilter02.html#Limits Hope this helps. Pete On Mar 28, 6:48*pm, anneten wrote: I am new to Excel and so please can you be very exact in any answers you might be able to give to me please. I have made a database/spreadsheet and at the top of the columns I've put filter arrows. That's fine. I can use them but now I find that in the drop down lists all the data (in this case names) does not appear. Can anyone tell me why, and how I can make them all appear in order to use them? Thanking you, -- anneten |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| Filter lists | Excel Discussion (Misc queries) | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| Filter arrows on drop down lists | Excel Discussion (Misc queries) | |||
Linear Mode
