Excel Autofilter - limitations?

[Guest]

Does the autofilter feature have a limit to how much it can search? I have a
jobfile list over 2500 entries and only seems to serach about half of them.

It there a setting to increase this search capablity if there is a default
limit or a workaround?

Thanks

 

[JE McGimpsey]

An autofilter list can only display the first 1000 items. See

http://contextures.com/xlautofilter02.html

 

[Guest]

I far as I knew the autofilter list (i.e. the list that is shown) only shows
the first 1000 entries BUT the custom filter will search the entire range,
i.e. Up to 64,000 or so records/rows.

 

[Paul]

I far as I knew the autofilter list (i.e. the list that is shown) only shows
the first 1000 entries BUT the custom filter will search the entire range,
i.e. Up to 64,000 or so records/rows.

Autofilter will only show the first 1000 items in the dropdown, its
not limited to 1,000 rows of data. More than likely you have a blank
row of data somewhere in your dataset.