Does Excel have an item limit when filtering?

J

Jacko at DHL

I am filtering on an excel sheet with around 11,000 rows (all items are
unique) and the filter drop-down only displays the first thousand or so.

Is this a bug or am I doing something wrong?
 
C

Chris

Another possibility is that you Auto filtered by selecting header row which
will work as long as there are no empty rows. Auto filter will not see rows
after the empty row. If there are empty rows, try auto filter by selecting
entire block (all cells)including your header row and activate auto filter.
 
Top