AutoFilter Question

[Guest]

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.

 

[Gord Dibben]

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

 

[Guest]

Gord,

Thanks for the info. So it is an Excel problem. I do feel that it is a bug
in Excel.