B
Brie
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?
can I fix this or what am I doing wrong?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
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)
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)
B
Brie
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.
need to filter by numbers in the rows.
M
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
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
K
Ken Wright
Take off the filter, select all the data and reset the filter.