Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using Filters
For some reason information that i have entered in the cell does not show up
when i pull down the filter list. Why is this happening? |
#2
|
|||
|
|||
Using Filters
Is there a break in your data list? Autofilter will only select data below
the heading until it reaches a blank row, unless you select the entire list before selecting autofilter. -- Ian -- "SJGLASS" wrote in message ... For some reason information that i have entered in the cell does not show up when i pull down the filter list. Why is this happening? |
#3
|
|||
|
|||
Using Filters
No, there does not seem to be any breaks. I had heard that it would only
filter up to 1,000 enteries. Is this true? "Ian" wrote: Is there a break in your data list? Autofilter will only select data below the heading until it reaches a blank row, unless you select the entire list before selecting autofilter. -- Ian -- "SJGLASS" wrote in message ... For some reason information that i have entered in the cell does not show up when i pull down the filter list. Why is this happening? |
#4
|
|||
|
|||
Using Filters
I don't know. I've never used it on a list that length.
-- Ian -- "SJGLASS" wrote in message ... No, there does not seem to be any breaks. I had heard that it would only filter up to 1,000 enteries. Is this true? "Ian" wrote: Is there a break in your data list? Autofilter will only select data below the heading until it reaches a blank row, unless you select the entire list before selecting autofilter. -- Ian -- "SJGLASS" wrote in message ... For some reason information that i have entered in the cell does not show up when i pull down the filter list. Why is this happening? |
#5
|
|||
|
|||
Using Filters
Up to 1000 unique entries will show in that dropdown.
Visit Debra Dalgleish's site for some workarounds: http://contextures.com/xlautofilter02.html#Limits SJGLASS wrote: No, there does not seem to be any breaks. I had heard that it would only filter up to 1,000 enteries. Is this true? "Ian" wrote: Is there a break in your data list? Autofilter will only select data below the heading until it reaches a blank row, unless you select the entire list before selecting autofilter. -- Ian -- "SJGLASS" wrote in message ... For some reason information that i have entered in the cell does not show up when i pull down the filter list. Why is this happening? -- Dave Peterson |
#6
|
|||
|
|||
Using Filters
I just tried Autofilter on over 6000 entries in one of my workbooks with no
problems. Not sure what's causing yours, sorry. I'd have to see the spreadsheet. Randall Arnold "SJGLASS" wrote: No, there does not seem to be any breaks. I had heard that it would only filter up to 1,000 enteries. Is this true? "Ian" wrote: Is there a break in your data list? Autofilter will only select data below the heading until it reaches a blank row, unless you select the entire list before selecting autofilter. -- Ian -- "SJGLASS" wrote in message ... For some reason information that i have entered in the cell does not show up when i pull down the filter list. Why is this happening? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help: Multiple filters with mutually exclusive items | Excel Discussion (Misc queries) | |||
Req: How to create multiple mutually exclusive filters | Excel Worksheet Functions | |||
filters logics | Excel Worksheet Functions | |||
How to aviod reset of Pivot filters when reconnecting to database? | Excel Discussion (Misc queries) | |||
How can I protect an excel worksheet containing filters? | Excel Discussion (Misc queries) |