Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table - Filtering Page Field | Excel Discussion (Misc queries) | |||
Filtering using dropdown box | New Users to Excel | |||
Filtering | Excel Discussion (Misc queries) | |||
Using Filtering | Excel Discussion (Misc queries) | |||
extracting numbers with no more than 8-digits using advanced filtering | Excel Worksheet Functions |