Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
PROBLEM WITH AUTOFILTER
I HAVE A WORKBOOK, AND I ACTIVATED THE AUTOFILTER DROPDOWN BOXES.
I NOTICED WHEN I OPEN THE DROPDOWN WINDOW OF THE AUTOFILTER OF A COLOM, I DO NOT SEE ALL THE DATA THAT IS IN THAT COLOM. IT SEEMS LIKE IT GOES TO A CERTAIN POINT AND THEN IT STOPS SHOWING ANYTHING AFTER IT. EXAMPLE: I HAVE A WHOLE BUNCH OF DATES IN THIS COLOM. THE DROPDOWN WINDOW ONLY GOES TO THE YEAR OF 2003. THERE ARE MORE ENTRIES THAT HAVE DATES AFTER THAT, BUT I CANT SEE IT IN THE AUTO FILTER SORRY FOR THE CAP LOCK. NEW USER HERE |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
PROBLEM WITH AUTOFILTER
The drop-down on the filter only lists up to 1000 different values, so
if you have more than this you will not see them in the drop-down. You can use Custom and then select greater than (for example) to see other values. Check this site for other ways around this limitation: http://www.contextures.com/tiptech.html Hope this helps. Pete OMIDF wrote: I HAVE A WORKBOOK, AND I ACTIVATED THE AUTOFILTER DROPDOWN BOXES. I NOTICED WHEN I OPEN THE DROPDOWN WINDOW OF THE AUTOFILTER OF A COLOM, I DO NOT SEE ALL THE DATA THAT IS IN THAT COLOM. IT SEEMS LIKE IT GOES TO A CERTAIN POINT AND THEN IT STOPS SHOWING ANYTHING AFTER IT. EXAMPLE: I HAVE A WHOLE BUNCH OF DATES IN THIS COLOM. THE DROPDOWN WINDOW ONLY GOES TO THE YEAR OF 2003. THERE ARE MORE ENTRIES THAT HAVE DATES AFTER THAT, BUT I CANT SEE IT IN THE AUTO FILTER SORRY FOR THE CAP LOCK. NEW USER HERE |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofilter problem | New Users to Excel | |||
Custom autofilter Bug In excel 2002 | Excel Discussion (Misc queries) | |||
Excel AutoFilter Problem | Excel Discussion (Misc queries) | |||
Autofilter problem | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |