AutoFilter Question

A

AccessHelp

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.
 
A

AccessHelp

Gord,

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