Filtering

[Guest]

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?

 

[Peo Sjoblom]

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)

 

[Guest]

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.

 

[Myrna Larson]

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

 

[Ken Wright]

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