Filtering
 

I can't get all of the items in a column to show up in the filter list. How
can I fix this or what am I doing wrong?

Autofilter has can show up to 1000 items, you can still use custom filtering
or help columns

http://www.contextures.com/xlautofilter02.html#Limits

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Brie" wrote in message
...
I can't get all of the items in a column to show up in the filter list.
How
can I fix this or what am I doing wrong?

That is the problem it is only like 10 items and only a few are showing up. I
need to filter by numbers in the rows.

"Peo Sjoblom" wrote:

Autofilter has can show up to 1000 items, you can still use custom filtering
or help columns

http://www.contextures.com/xlautofilter02.html#Limits

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Brie" wrote in message
...
I can't get all of the items in a column to show up in the filter list.
How
can I fix this or what am I doing wrong?

Then it sounds like you have an embedded blank row in your list, so Excel
thinks the list ends at that blank row. To fix this, select all of the data in
your list, including the headers, before you do Data/AutoFilter

On Wed, 9 Feb 2005 12:51:05 -0800, "Brie"
wrote:

That is the problem it is only like 10 items and only a few are showing up. I
need to filter by numbers in the rows.

"Peo Sjoblom" wrote:

Autofilter has can show up to 1000 items, you can still use custom
filtering
or help columns

http://www.contextures.com/xlautofilter02.html#Limits

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Brie" wrote in message
...
I can't get all of the items in a column to show up in the filter list.
How
can I fix this or what am I doing wrong?

Take off the filter, select all the data and reset the filter.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Brie" wrote in message
...
That is the problem it is only like 10 items and only a few are showing
up. I
need to filter by numbers in the rows.

"Peo Sjoblom" wrote:

Autofilter has can show up to 1000 items, you can still use custom
filtering
or help columns

http://www.contextures.com/xlautofilter02.html#Limits

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Brie" wrote in message
...
I can't get all of the items in a column to show up in the filter list.
How
can I fix this or what am I doing wrong?