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.