Cannot filter more than 10,000 rows

I have 40,000 rows of data in an Excel spreadsheet but am having trouble filtering the data. It stops at 10,000 rows.
 

Question Info


Last updated January 22, 2019 Views 28,031 Applies to:
Answer

The AutoFilter actually does work on all 40,000 records.  The limitation is in the number if unique items it can list in the dropdown: 10,000 which is a significant increase over Excel 2003's limit.

Does that information help?


Ron Coderre
Microsoft MVP - Excel (2006 - 2010)

P.S. If any post answers your question, please mark it as the Answer (so it won't keep showing as an open item.)
Regards,

Ron Coderre
Microsoft MVP - Excel

187 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.