Using Filters

[SJGLASS]

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?

[Ian]

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" <SJGLASS@discussions.microsoft.com> wrote in message
news:001950D2-EBCA-473F-89B8-EE80FA04FE50@microsoft.com...
> 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?

[SJGLASS]

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" <SJGLASS@discussions.microsoft.com> wrote in message
> news:001950D2-EBCA-473F-89B8-EE80FA04FE50@microsoft.com...
> > 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?
>
>
>

[Ian]

I don't know. I've never used it on a list that length.

--
Ian
--
"SJGLASS" <SJGLASS@discussions.microsoft.com> wrote in message
news:0FFED156-2C7C-45A5-9643-915CB2AE5132@microsoft.com...
> 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" <SJGLASS@discussions.microsoft.com> wrote in message
>> news:001950D2-EBCA-473F-89B8-EE80FA04FE50@microsoft.com...
>> > 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]

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" <SJGLASS@discussions.microsoft.com> wrote in message
> > news:001950D2-EBCA-473F-89B8-EE80FA04FE50@microsoft.com...
> > > 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

[Randall Arnold]

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" <SJGLASS@discussions.microsoft.com> wrote in message
> > news:001950D2-EBCA-473F-89B8-EE80FA04FE50@microsoft.com...
> > > 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?
> >
> >
> >