Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoFilter Question
I have an Excel file that contains 5000 records. When I do the AutoFilter of
all records and when I click on the AutoFilter drop-down arrow of a column, I do not see all the information in the list. Therefore, I can not select the information that I want to filter. However, if I do the custom from the drop-down arrow and type in the criteria, I can then filter the info that I want. Does anyone know why Excel does not show all the info in the drop-down arrow? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoFilter Question
We don't know why the developers chose to show only 1000 records maximum, but
using the "Custom" is one way of getting around the limitation. More workarounds at Debra Dalgleish's site. http://www.contextures.on.ca/xlautofilter02.html#Limits Gord Dibben MS Excel MVP On Fri, 29 Sep 2006 09:36:02 -0700, AccessHelp wrote: I have an Excel file that contains 5000 records. When I do the AutoFilter of all records and when I click on the AutoFilter drop-down arrow of a column, I do not see all the information in the list. Therefore, I can not select the information that I want to filter. However, if I do the custom from the drop-down arrow and type in the criteria, I can then filter the info that I want. Does anyone know why Excel does not show all the info in the drop-down arrow? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoFilter Question
Gord,
Thanks for the info. So it is an Excel problem. I do feel that it is a bug in Excel. "Gord Dibben" wrote: We don't know why the developers chose to show only 1000 records maximum, but using the "Custom" is one way of getting around the limitation. More workarounds at Debra Dalgleish's site. http://www.contextures.on.ca/xlautofilter02.html#Limits Gord Dibben MS Excel MVP On Fri, 29 Sep 2006 09:36:02 -0700, AccessHelp wrote: I have an Excel file that contains 5000 records. When I do the AutoFilter of all records and when I click on the AutoFilter drop-down arrow of a column, I do not see all the information in the list. Therefore, I can not select the information that I want to filter. However, if I do the custom from the drop-down arrow and type in the criteria, I can then filter the info that I want. Does anyone know why Excel does not show all the info in the drop-down arrow? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFilter toggling in VBA (How to use correctly) | Excel Discussion (Misc queries) | |||
Improve autofilter combine conditionals with filter criteria | Excel Worksheet Functions | |||
Custom Autofilter List | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
autofilter problem | Excel Worksheet Functions |